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
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
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
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
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
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
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
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
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
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
Answer Question | May 19, 2011 6:27 AM
CL, CPF0000, CPF9999
When I run a vb pgm in CL, the screen hangs.
Answer Question | October 29, 2009 3:57 PM
CL, Visual Basic
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
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
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
Can we update a file in CL? If so how?
Answer Question | February 22, 2010 6:22 AM