Deleting IFS records after so many days
Can anyone provide CL code that would delete records within a date range? I would like to delete entries, say-that are 35 days old from the IFS.
Answer Question
| January 14, 2013 7:32 PM
AS/400, CL Commands, IFS
Can anyone provide CL code that would delete records within a date range? I would like to delete entries, say-that are 35 days old from the IFS.
CL command to compare *QRYDFN files
Is there a CL command like CMPPFM(Compare physical file member) to compare *QRYDFN files. The Process of doing Manual Comparison of *QRYDFN files is tedious and time consumming. Is there a cl command to simplify this process? Thanks.
Answer Question
| March 19, 2012 11:04 AM
*QRYDFN, CL Commands, iSeries
Is there a CL command like CMPPFM(Compare physical file member) to compare *QRYDFN files. The Process of doing Manual Comparison of *QRYDFN files is tedious and time consumming. Is there a cl command to simplify this process? Thanks.
create 39 barcode using PCL commands
what is PCL command for 39 barcode sent from AS400
Answer Question
| October 6, 2011 12:34 PM
AS/400 commands, CL Commands, PCL, RPG/400
what is PCL command for 39 barcode sent from AS400
Using CL Commands
Hi, How run the cl commands using rpg/400? how to use the chkobj command in rpg program? (That mean without using command line from wrkmbrpdm?
Answer Question
| March 31, 2012 10:27 AM
AS/400 objects, CL Commands, RPG/400
Hi, How run the cl commands using rpg/400? how to use the chkobj command in rpg program? (That mean without using command line from wrkmbrpdm?
Need to use the cpytoimpf command but have problem
I have an existing process that uses the following command the only change was to have it use the tildes (~) as a field delimiter. CPYTOIMPF FROMFILE(*LIBL/BDPRISM) TOSTMF(‘/home/attach/vhaeom2/vhasales.txt’) MBROPT(*REPLACE) STMFCODPAG(1252) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM(‘~’) But the command the command execute without error but the tilde is not place between the fields. Below is a small [...]
Answer Question
| June 20, 2011 6:55 PM
CL Commands, CPYTOIMPF, iSeries Commands
I have an existing process that uses the following command the only change was to have it use the tildes (~) as a field delimiter. CPYTOIMPF FROMFILE(*LIBL/BDPRISM) TOSTMF(‘/home/attach/vhaeom2/vhasales.txt’) MBROPT(*REPLACE) STMFCODPAG(1252) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM(‘~’) But the command the command execute without error but the tilde is not place between the fields. Below is a small [...]
Write a CL to update all jobds on system
I need to write a CL that will change every jobd on our system w/o having to do it manually.
Answer Question
| May 18, 2011 4:28 PM
AS/400 jobs, CL, CL Commands, CL Procedure, JOBD
I need to write a CL that will change every jobd on our system w/o having to do it manually.
Writing command WJ that will do the same thing as WRKACTJOB?
need you help once more. I want to create a cl program. instead of wrinting wrkactjob, i want to write wj having the same result. The problem is i don´t know programming, so if somebody could make a clp to me so i could read it and understand it, it would be great. Tanx a [...]
Answer Question
| May 6, 2011 3:41 PM
CL Commands, CL Program, CLPROGRAM, WRKACTJOB
need you help once more. I want to create a cl program. instead of wrinting wrkactjob, i want to write wj having the same result. The problem is i don´t know programming, so if somebody could make a clp to me so i could read it and understand it, it would be great. Tanx a [...]
CPA4088 responds automatically?
Hello Friends, I Have a CL with commands below SAVLIB: SAVLIB LIB(BKPLIB) DEV(TAP01) ENDOPT(*LEAVE) + SAVACT(*SYNCLIB) SAVACTMSGQ(SYNCBKP) + ACCPTH(*YES) OUTPUT(*PRINT) MONMSG MSGID(CPF0000) EXEC(GOTO CMDLBL(ERROR)) GOTO CMDLBL(SAIDA) ERROR: SNDMSG MSG(‘TEXT TEXT TEXT TEXT’) TOUSR(QSYSOPR) SAIDA: ENDPGM When the tape needs a second volume, the process ends with “C” on the message [...]
Answer Question
| May 3, 2011 9:43 AM
AS/400, AS/400 - CL Command, CL Commands, CPA
Hello Friends, I Have a CL with commands below SAVLIB: SAVLIB LIB(BKPLIB) DEV(TAP01) ENDOPT(*LEAVE) + SAVACT(*SYNCLIB) SAVACTMSGQ(SYNCBKP) + ACCPTH(*YES) OUTPUT(*PRINT) MONMSG MSGID(CPF0000) EXEC(GOTO CMDLBL(ERROR)) GOTO CMDLBL(SAIDA) ERROR: SNDMSG MSG(‘TEXT TEXT TEXT TEXT’) TOUSR(QSYSOPR) SAIDA: ENDPGM When the tape needs a second volume, the process ends with “C” on the message [...]
Journaling on i5 when updating from .net
We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?
Answer Question
| May 2, 2011 3:41 PM
.NET, AS/400 journaling, CL Commands, i5, iSeries V6R1, SQL Server
We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?
Interactive command in CL
How to successfully compile a CL program that has an interactive command such as STRSEU?
Answer Question
| May 2, 2011 2:13 PM
AS/400 - CL Command, CL Commands, STRSEU
How to successfully compile a CL program that has an interactive command such as STRSEU?
QPNQRY start over
Is there a CL command to restart/reset an Open Query from the beginning ? I could repeat the OPNQRYF command, but that’s silly if a single command does the same thing Mike
Answer Question
| March 21, 2011 4:16 PM
AS/400 - CL Command, AS/400 command functions, CL Commands, OPNQRYF
Is there a CL command to restart/reset an Open Query from the beginning ? I could repeat the OPNQRYF command, but that’s silly if a single command does the same thing Mike
While calling a command via a CL program exposes my command line.
While calling a command via a CL program exposes my command line. Is it possible to hide the command line while executing the command via cl. I need to do this as iam executing the cl with adopted authority.
Answer Question
| February 15, 2011 5:39 AM
AS/400, AS/400 commands, CL Commands, CL Program, CL programming, iSeries
While calling a command via a CL program exposes my command line. Is it possible to hide the command line while executing the command via cl. I need to do this as iam executing the cl with adopted authority.
Displaying on the message line through CL
Thru CL how can I display a message on the message line?
Answer Question
| January 11, 2011 7:17 AM
AS/400 messaging, CL Commands, CL Program
Thru CL how can I display a message on the message line?
OVRDBF -POSITION
Hi, How to position the record in CL based on the key value? I have tried this.my CL program is as follows… *************************** PGM DCLF FILE(PMS90/EMPMST90) [...]
Answer Question
| January 12, 2011 6:51 AM
CL Commands, CL Program, CL/400, OVRDBF
Hi, How to position the record in CL based on the key value? I have tried this.my CL program is as follows… *************************** PGM DCLF FILE(PMS90/EMPMST90) [...]
CL date extraction in AS/400
I want to take out date value from today to last 7 days in CL command. Kindly help
Answer Question
| January 7, 2011 11:02 AM
AS/400, AS/400 commands, CL Commands, CL Program
I want to take out date value from today to last 7 days in CL command. Kindly help
How to run a command within a CLP only during a specific time frame
I have a pgm that perfroms verious system checks and alerts me if there is a problem. I would like to add an If statement to exclude some of the checks that fall between a certain time period and have it jump to a specific lable in the script to continue. thus skipping over the commands [...]
Answer Question
| December 28, 2010 7:26 AM
AS/400, CL Commands, CLP, IF statement
I have a pgm that perfroms verious system checks and alerts me if there is a problem. I would like to add an If statement to exclude some of the checks that fall between a certain time period and have it jump to a specific lable in the script to continue. thus skipping over the commands [...]
Launching a browser window from JBA Explorer 6.3.1
Ouside of the JBA Explorer build 6.3.1 (iSeries OS V5R3) I can launch a browser window via a CL on a commandline. Inside the JBA Explorer I cannot. Ideas anyone???
Answer Question
| November 24, 2010 9:53 PM
CL Commands, JBA, JBA AS/400 STRPCCMD, OS V5R3M0
Ouside of the JBA Explorer build 6.3.1 (iSeries OS V5R3) I can launch a browser window via a CL on a commandline. Inside the JBA Explorer I cannot. Ideas anyone???
Simulate a key stroke using CL on an AS/400 system?
Just currious, but is there a way to simulate a key stroke like the >enter< key within a cl prog on an as400 system? Thanks.
Answer Question
| November 1, 2010 10:14 AM
AS/400, AS400 iseries, CL Commands, CL programming, Control Language Programming
Just currious, but is there a way to simulate a key stroke like the >enter< key within a cl prog on an as400 system? Thanks.
CL Command definition parameter with Mixed valid values
Hello, I want to create a command with a parameter same as Stream file code page in CPYTOSTMF. It shoud allow only 1 – 32657, *STMF, *PCASCII, *STDASCII. Can someone explain how could I declare parameter to have this ? Thanks Sim
Answer Question
| November 1, 2010 4:09 AM
AS/400, CL, CL Commands, CL Parameters, CPYTOSTMF, Stream files
Hello, I want to create a command with a parameter same as Stream file code page in CPYTOSTMF. It shoud allow only 1 – 32657, *STMF, *PCASCII, *STDASCII. Can someone explain how could I declare parameter to have this ? Thanks Sim
Using CL to COPY text files to QNTC share
I have tried to use CPY to copy file from the AS400 to a QNTC windows share and I get an error that the command is not supported. What command can I use to copy these file over?
Answer Question
| October 8, 2010 2:19 PM
AS400 Command, CL Commands, QNTC File System
I have tried to use CPY to copy file from the AS400 to a QNTC windows share and I get an error that the command is not supported. What command can I use to copy these file over?





