My operating system was upgraded from V5R3 to V5R4
my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting executed fine on a separate box which still is [...]

Answer Question   |  June 12, 2013  12:52 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Project management, RPG, RPGLE

Creating a CL Command using *SAME as a parameter
Hi, I’m currently creating a *PGM and *CMD to allow local IT sites to update a few options on a CHGUSRPRF but have hit an issue with the OUTQ parameter. The CMD screen will show *SAME for all of the parameters as below. User Profile . . . . . . . . . . [...]

Answer Question   |  March 23, 2007  6:05 AM
CLP

OVRPRTF not working in procedure that is called
Have an RPGLE program that calls a external procedure, which does an OVRPRTF (through a RunCL function), and then prints a report. The problem is, that the OVRPRTF doesn’t seem to be doing it’s job. Does this have something to do with the procedure? I originally had a CL that was called (from the RPG) [...]

Answer Question   |  March 19, 2010  1:52 PM
CLP, RPGLE

SENDING A BREAK MESSAGE
I HAVE WRITTEN A CL PROGRAM WHICH USES QEZSNDMG TO SEND A BREAK MESSAGE TO SPECIFIC USERS. IT WORKS PERFECTLY EXCEPT IF THE USER ISN’T SIGNED ON, HE DOES NOT GET THE MESSAGE UNLESS HE DOES A DSPMSG. IS THERE A WAY TO MAKE THE MESSAGE AUTOMATICALLY POP UP AFTER THE USER SIGNS ON?

Answer Question   |  January 3, 2010  9:13 PM
CLP, RPG, RPGLE

CL code to work on a spoolfile
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don’t want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. [...]

Answer Question   |  January 3, 2010  7:25 AM
Application development, AS/400, CLP

CL coding for restart after abort
I am looking for examples of how to code a CL program to restart at the appropriate job step after an abort. The technique involves saving the last successfully completed step into a *DTAARA. This is done throughout the CL. Then when the CL job is restarted, the first thing the CL does is rtvdtaara. [...]

Answer Question   |  March 5, 2007  5:26 PM
CLP

AS400 disk initialize info
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of “COMLETED SUCCESSFULLY” I need more infomation like model, serial no, sectors or some proof that this particular disk has passed for the [...]

Answer Question   |  January 4, 2010  5:00 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, RPG, RPGLE, Security

OPNQRY Question
Answer Updated

Answer Question   |  January 2, 2010  3:20 PM
AS/400, CLP, RPG, RPGLE

Access remote files from a CL program
New Answer

Answer Question   |  February 15, 2007  9:56 AM
AS/400, CLP

Scheduling Batch Job (Files in Multiple Libraries)
Dear All, I need to schedule a batch job, In which I would call a program to run, it will call another program which exists in other library. And program updates the data in files in Multiple Libraries. If I schedule the Job, which calls main program, again while main program calling another program(exists in [...]

Answer Question   |  December 29, 2009  7:06 AM
AS/400, CLP, DataCenter

SQL
I have a beginner SQL question. I’m new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How [...]

Answer Question   |  June 20, 2008  4:53 PM
Application development, AS/400, CLP, RPG, RPGLE, SQL Server

Emailing from iSeries with multiple attachments
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be done? Thanks [...]

Answer Question   |  January 22, 2007  11:15 AM
Application development, AS/400, CLP, Email

Stored Procedures called from RPG programs
I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive [...]

Answer Question   |  December 23, 2010  1:41 PM
AS/400, CLP, RPG, RPGLE, Web development

Reg Data extraction from one environment to another
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from particular environment. [...]

Answer Question   |  January 17, 2007  4:26 AM
Application development, AS/400, CLP, RPGLE

AS400 intreface with other platforms
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example

Answer Question   |  December 29, 2009  1:30 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, Security, Web development

Getting job log info into RPGLE program
I’m looking for an easy way to get “error” information from the job log into my RPGLE Program. I’m “monitoring” a CHAIN to a file for an “unable to allocate” error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks

Answer Question   |  January 5, 2007  10:49 AM
CLP, RPGLE

using SQL statements…………..
Hi All, I have a problem. I have a string variable STR which contains SQL statements…… Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable…means I update the values of library and files at run time…in the variable STR.. I want to execute the SQL statements contained in string STR… How can [...]

Answer Question   |  December 23, 2010  9:52 AM
CLP, DB2 Universal Database, RPGLE

Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]

Answer Question   |  January 7, 2007  10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development

Using two same files from different libraries in a RPGLE program.
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]

Answer Question   |  December 28, 2009  4:15 AM
CLP, DB2 Universal Database, RPGLE

Is it possible to reorganize a very big transaction in one night?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

Answer Question   |  December 28, 2009  4:43 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security