Saving spool files from an AS400, restoring spool files to a different AS400
Hello Does anyone have any previous knowledge on how to save spool files on one AS400, (presumably to tape back up), and then perform a restore operation of these spool files on a different AS400. Note that the client is at V5R3. I am hoping that we can do this procedure with C/L programs ? [...]

Answer Question   |  December 23, 2010  1:34 PM
AS/400 backup, AS/400 storage, CL, Spool files

How do I find out how many lines of source code are on the system?
Hello. I’m trying to write a program that will tell me how many lines of source code reside on our system. I figured out the first couple of steps, but it just gets more and more confusing along the way, and I really think there’s gotta be a better way to get the information i [...]

Answer Question   |  April 26, 2011  1:52 PM
CL, iSeries development, ODCRTS, ODSRCF, ODSRCL, ODSRCM, QRPGLESRC, QSYS.LIB, RPGLE, RTVNETA

INDICATORS- Can function keys be defined and looked for in a CL program
Can function keys be defined and looked for in a CL program. IF a CL program is used to run a Query with a prompted select, and the user presses F3, Can I trap this?

Answer Question   |  March 14, 2008  9:47 PM
AS/400, CL

RUNSQLSTM
am executing a RUNSQLSTM out of a CL program that run a source SQL statement in a source file of a library. Everytime the statement is executed I get a output spool file of the SQL parmeters and execution results. How can I prevent this?

Answer Question   |  May 20, 2011  7:41 PM
CL, RUNSQLSTM, SQL

Capacity management
As part of capacity management, we need to collect data on disk utilization, cpu utilization, memory utilization of our AS400 servers. Is it possible to retrieve all these information using a program? If yes, kindly provide me the programs to do the same. Is there any other technique that can be used to collect these [...]

Answer Question   |  March 27, 2008  6:04 AM
CL, REXX

call php from cl
Hello, i call a php program from my cl with CALL PGM(QP2SHELL) … the php is called, but then opens the QSHELL. can i close the QSHELL from my php programm? Or can i call a php programm without starting qshell? btw. can i sent parms back to the cl from php? Thanks for your [...]

Answer Question   |  April 7, 2010  4:15 PM
AS/400, CL, PHP, Qshell

Download from the AS400 tab delimited file
I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so [...]

Answer Question   |  February 13, 2008  4:13 PM
AS/400, CL, DB2

User Exit Programs-FTP
Hello I am strggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture the user id [...]

Answer Question   |  February 5, 2008  2:20 PM
CL, RPGLE, User Exit Program FTP

iSeries PDM CRTBNDRPG Parameters
Hello The question is a bit long but the answer should be short so here it is. In order to run some pre/post-compile processing of RPG program I’m looking for a way of replacing QRN4CPP (CPP of CRTBNDRPG) with a CL program of my own that wil run Pre-Compile, Invoke the original QRN4CPP and then [...]

Answer Question   |  January 23, 2008  4:04 PM
AS/400, CL, CRTBNDRPG, CRTRPGMOD, iSeries, Programming, QRN4CPP, RPG

Scheduling queries in AS/400
What is the easiest way to schedule several queries to run several times throughout the day??? Will the Advanced Job Scheduler accomplish this or would writing a simple CL program be easier? Or is there any other methods?

Answer Question   |  January 2, 2008  11:22 PM
Advanced Job Scheduler, CL, Query, Scheduling

what is diff b/w CPF0000 and CPF9999
what is diff b/w CPF0000 and CPF9999

Answer Question   |  May 19, 2011  6:27 AM
CL, CPF0000, CPF9999

running a vb pgm in CL hangs
When I run a vb pgm in CL, the screen hangs.

Answer Question   |  October 29, 2009  3:57 PM
CL, Visual Basic

SQL and CL
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?

Answer Question   |  December 25, 2007  5:33 PM
CL, RPGLE, SQL

Need to make a parameter required !
I want to code a *cmd with four parameters. 1. I want all of them to be required ( i.e. pressing enter without typing anything should issue a error message “Parameter BLABLA required”) 2. I want to check at a *cmd level , not at the *pgm level behind the command if the entered parameter [...]

Answer Question   |  March 1, 2010  9:07 AM
CL, CMD, parameter, required

Inquiry Message Reply
I am working with 2 iSeries Servers both running V5R3M5. I have a job that runs on both systems that detaches and attaches journal receivers. A CPA7025, Receiver never fully saved, is issued at times. One of the first statements in the CLP is CHGJOB INQMSGRPY(*DFT) so the Default Message Reply is used, which is [...]

Answer Question   |  February 21, 2010  7:04 PM
CL, iSeries

Updating a file in cl?
Can we update a file in CL? If so how?

Answer Question   |  February 22, 2010  6:22 AM
AS/400, CL