I need to be able to call an RPG program from an iSeries Stored Procedure. The program that we have is that when the procedure is called an error is returned that the program cannot be found ...
I'm attempting to create an OUTQ that will spool labels to a Zebra QL420 plus wireless printer. The queue currently feeds a single label but is not printing the label zpl. I can create a clien...
I am having problems witgh passing of variables to a CL program. The variables are as follows
parm1 = '1' (possible 11 long)
parm 2 = '070808' (possible 6 long)
parm3 = 'This is a test ...
Hi
I'm using an OLE DB provider connection string similar to this.
cn2.Open("Provider=IBMDADB2;Database=JDEENT;Hostname=172.16.1.10;Protocol=TCPIP;Port=8476; Uid=RLEE;Pwd=PEARL")
I'm getti...
Hi,
I'm new to AS/400, but I have programming experience.
I'd like to create a macro (in AS400 or Excel VBA, doesn't matter) that copies cell data from an xls spreadsheet to AS/400. How wo...
What is the name of the font on the AS400? I need to use it in Windows so Im trying to find the equivalent.
Thanks.
I have a bunch of output queues in the system that are not used and just clutter up the view when I go into 'WRKOUTQ' and so I would like to delete them. When I go into 'DLTOUTQ' I enter all ...
Hi,
I am printing out of AS/400 on a Ricoh printer. I am printing a 11x17 page and you can feed that type of paper on the bypass tray. The default on the printer is letter size. When i prin...
I'm working with an AS400 i5 series system (and a serious noob to the 400!). Currently user queries are produced by a report-writing operator using Query400. These queries tend to be somewhat ...
Hi,
I am trying to get the attributes of all the spool files sent to a specific OUTQ after my batch process stored into a physical file , usually i will do it manually by searching and copy...
Windows Logon credentials are unavailable error message coming up when attempting to connect to iSeries server.
This has never come up before, and it as always prompted for credentials inst...
I need to compare the data in both, to find all new employees that are not in the active directory, my key's are going to be the Employee Number, after i get the new information I would like t...
Is it possible to deploy a .net app and just set up the odbc settings for the AS400 without Client Access?
Dear Experts Exchange Team,
I have a critical problem in AS400 data fetch query in MS Excel (Petch SP2 loaded).
I have created several Excel Sheets (in MS Office 2003) for fetching the ...
I've searched the web over...
Please give me a meaningful example of changing 'MOVEA' statements to RPG Free-format?
Thanks,
Phil
I have a dinosaur as400 that still needs to be accessed but I need to change the ip address on it. Can anyone point me in the right direction? I have search the web but everything i try does n...
Hi,
I am looking at streamlining all or part of a process which involves doing many recompiles of source programs each year. These source programs are contained in a common library. The bas...
We have a program in our AS400 that is scheduled to run every night to backup User data. I want to view the source code within the file. I simply want to look at it but for the life of me I do...
AS400 supports two sites (Site A, 192.168.2.0 and Site B 192.168.1.0) 400 was physically at Site A.
Had to move to Site B.
Changed IP address on 400.
Everything works fine except remote pr...
Command to find the total size of the library in AS400. I am using the command DSPLIB OUTPUT(*PRINT),but this is going to print almost 600 pages to display the total size of the library.
We just installed a new AS400, restored our old system and now the line printer does not seem to have the correct line spacing any longer.
The printer is the same printer we had before and I ...
Hello,
Is there a way to display an AS400 Spool File in the browser using ASP.Net Technology?
I am connecting to an AS400, using Microsoft Access 2003, via ODBC (Client Access). The problem I am having is that some of the tables on the AS400 have a dot (.) as part of the table name. (E...
I have a lib with a table A, in it I have 4 members. I can't seem to view them from iSeris Navigator. I can select properties, and see them as partitions, but when I select view contents, al...
- SQL statement failing when any fiels has a $ in the name descriiption.
SELECT * PROD.F1234 WHERE FIRST$NAME = "Smith"'
Does any one have a work around? This seems to be a JD Edward...
