how to write all the matching records in to antoher file in CL program
hi, i am having a pf in that pf contain many members, using display file i have to search a perticular string in all the members if it is found these matching records want to write into another file this is my requirement. in CL grogram how to do this? using FNDSTRPDM can we do that, please...
hi, i am having a pf in that pf contain many members, using display file i have to search a perticular string in all the members if it is found these matching records want to write into another file this is my requirement. in CL grogram how to do this? using FNDSTRPDM can we do that, please...
85 pts.
DSPF & SNDRCVF
In a CL, I need to define two files. One file is a display file and the other is a physical file. Then I need to do a RCVF to pass the retrieve data in the display file then use the physical file. When I try to compile the pgm using the RCVF, it does not recognize the variables in the display file...
In a CL, I need to define two files. One file is a display file and the other is a physical file. Then I need to do a RCVF to pass the retrieve data in the display file then use the physical file. When I try to compile the pgm using the RCVF, it does not recognize the variables in the display file...
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 ?...
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 ?...
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 need. So far, this...
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 need. So far, this...
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?
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?
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?
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?
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...
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...
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 help i am just...
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 help i am just...
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 that it will run unattended. ...
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 that it will run unattended. ...
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...
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...
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...
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...
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?
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?
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?
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?
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 contains a...
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 contains a...
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...
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...
