Unable to run CPYSPLF command multiple times to same output file in a single CL.
Iam running CPYSPLF command to an output file once, I process the resultant output file thereafter when i move on to the next spool file by again running the CPYSPLf Command on the same output file which required existing data to be cleared and overwritten with the data received from the second...
Iam running CPYSPLF command to an output file once, I process the resultant output file thereafter when i move on to the next spool file by again running the CPYSPLf Command on the same output file which required existing data to be cleared and overwritten with the data received from the second...
380 pts.
Callin CLP with parameter
Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm('14' 'aaaaa') But it takes value as F1F44040404040. Hel me out soon. Thanks in...
Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm('14' 'aaaaa') But it takes value as F1F44040404040. Hel me out soon. Thanks in...
not a valid Query Management variable.
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...
Can i declare a display file and a physical file in a single CL
Can i declare a display file and a physical file in a single CL. Also can u share a sample program, which uses the parameters entered in the display file (using SNDRCV command) and processes records from a physical file.
Can i declare a display file and a physical file in a single CL. Also can u share a sample program, which uses the parameters entered in the display file (using SNDRCV command) and processes records from a physical file.
Displaying data through DSPF and CL programm.!
I would like to be able to display one record from my PF with DSP file through a CL program on my screen. I have these sources: CL program: ******************************************** QSYSPRT 1 QPADEV0021 USERNAME pgm ...
I would like to be able to display one record from my PF with DSP file through a CL program on my screen. I have these sources: CL program: ******************************************** QSYSPRT 1 QPADEV0021 USERNAME pgm ...
Jobs goes into Message Wait after reaching End Of File.
I am using the below programs to Delete Temporary Files from Specific Libraries on monthly basis after taking a Entire System Backup. [strong]The File and Library Names are stored in a Output File called MNTHDELE in QGPL and the Column Names are &ODLBNM for File Name and &ODOBNM for Library...
I am using the below programs to Delete Temporary Files from Specific Libraries on monthly basis after taking a Entire System Backup. [strong]The File and Library Names are stored in a Output File called MNTHDELE in QGPL and the Column Names are &ODLBNM for File Name and &ODOBNM for Library...
Controlling JDE app outage times during CL reorg
We currently run a weekly reorg controlled by a CL program. Until recently we had a four hour window and are now looking to do the reorgs with the smallest possible JDE application outage. Any recommendations?
We currently run a weekly reorg controlled by a CL program. Until recently we had a four hour window and are now looking to do the reorgs with the smallest possible JDE application outage. Any recommendations?
SAVOBJ
I am trying to use the SAVOBJ command to copy files to a save file. Is there a way to add to the save file and not write over it with each SAVOBJ call? I know I can create a list of files and send all of them to one save file but I would rather just add to the save file if possible. Thanks
I am trying to use the SAVOBJ command to copy files to a save file. Is there a way to add to the save file and not write over it with each SAVOBJ call? I know I can create a list of files and send all of them to one save file but I would rather just add to the save file if possible. Thanks
Parameter list is not refreshed from previous calls
I created a command with validity checker defined. The validation work fine but the parameter list is not refreshed from previous calls to the command. I've defined a simple list for "user name " parameter in my command. If I give 3 user names (A, B, & C) in the list, in the next call even if I...
I created a command with validity checker defined. The validation work fine but the parameter list is not refreshed from previous calls to the command. I've defined a simple list for "user name " parameter in my command. If I give 3 user names (A, B, & C) in the list, in the next call even if I...
How to read a text file to use for variables in CL
I have a CL that saves libraries as savf files to later FTP to a storage device. For each library I have a set of commands that specifiy the specific library and the specific savf file for that library. The commands are repeated three times, once for each library/savf file. I would like to have...
I have a CL that saves libraries as savf files to later FTP to a storage device. For each library I have a set of commands that specifiy the specific library and the specific savf file for that library. The commands are repeated three times, once for each library/savf file. I would like to have...
List of Outfiles
I've seen a list of the System Supplied Outfiles in one of the manuals. Can anyone direct me to that manual ? Thanks, Bill Poulin
I've seen a list of the System Supplied Outfiles in one of the manuals. Can anyone direct me to that manual ? Thanks, Bill Poulin
Delete old spool files
The following question was recently submitted by a user via e-mail: I am trying to create a program in CL to delete old spool files on the AS400. I am using the following code, but my program does not recognize any of the commands. Does anyone have any suggestions or solutions? Thank you very...
The following question was recently submitted by a user via e-mail: I am trying to create a program in CL to delete old spool files on the AS400. I am using the following code, but my program does not recognize any of the commands. Does anyone have any suggestions or solutions? Thank you very...
How to extract data to the various excel sheets in a CL.
Hi, I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files. Can someone show me how to use the various sheets in excel to store the data and how...
Hi, I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files. Can someone show me how to use the various sheets in excel to store the data and how...
Override to a Logical File
hi, I am trying to create an override to a logical file. I have a PF File A which has a logical AL1. My CL program can run in a build/copy mode where Build would just build the work file and copy would build & copy the workfile etc. The CL has an override to A called B and then calls the RPGLE...
hi, I am trying to create an override to a logical file. I have a PF File A which has a logical AL1. My CL program can run in a build/copy mode where Build would just build the work file and copy would build & copy the workfile etc. The CL has an override to A called B and then calls the RPGLE...
QMQRY not a valid Query Management variable.
Hi there, I am trying to pass parameters to QMQRY but get the following error. CALL PGM(JCCSTREP2) PARM(C165) 'C165' is not a valid Query Management variable. Error found on STRQMQRY command. CPF0001 received by JCCSTREP2 at 2800. (C D I R) ...
Hi there, I am trying to pass parameters to QMQRY but get the following error. CALL PGM(JCCSTREP2) PARM(C165) 'C165' is not a valid Query Management variable. Error found on STRQMQRY command. CPF0001 received by JCCSTREP2 at 2800. (C D I R) ...
MONITOR FOR HELD LOCKS
I created this pgm to check if a file is being locked. I would like to trap if there is a hold lock. If I can I would like to loop back if there is a hold until the hold is released. WRKOBJLCK OBJ(MCPARMS) OBJTYPE(*FILE) ...
I created this pgm to check if a file is being locked. I would like to trap if there is a hold lock. If I can I would like to loop back if there is a hold until the hold is released. WRKOBJLCK OBJ(MCPARMS) OBJTYPE(*FILE) ...
Inside a running CL program can you find the lib that the program is running from?
Can you find in a running CL program the lib that it was started from? For example in a C program you can get the library name from argv[0].
Can you find in a running CL program the lib that it was started from? For example in a C program you can get the library name from argv[0].
clearing multple members in a physical file
Does anyone know of a way (or utility) to clear multiple members in a physical file ? i create multiple members for the file on the fly based upon date/time in a cl program. the file is a weekly archive of data from a transaction processor, and i want to clear it and start over on a weekly...
Does anyone know of a way (or utility) to clear multiple members in a physical file ? i create multiple members for the file on the fly based upon date/time in a cl program. the file is a weekly archive of data from a transaction processor, and i want to clear it and start over on a weekly...
