CLP Programming
PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?
Answer Question
| March 18, 2013 9:47 AM
CL programming, CLP
PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?
Retrive System value in CCYYMMDDHHMMSS format?
Hi anyone tell me how to retrive system valule in format CCYYMMDDHHMMSS in which CC in centuary?
Answer Question
| March 17, 2012 6:32 AM
CL programming, CLLE
Hi anyone tell me how to retrive system valule in format CCYYMMDDHHMMSS in which CC in centuary?
CL Back up job failing
I have a backup job which fails to back up the first 4 objects and I believe it’s down to my programmer bad programming. This program:- 2100 PGM PARM(&LEDGER) 2200 DCL VAR(&LEDGER) TYPE(*CHAR) LEN(2) 2300 DCL VAR(&OBJLIB) TYPE(*CHAR) LEN(10) 2400 DCL VAR(&SECULIB) TYPE(*CHAR) LEN(10) 2500 DCL VAR(&JRNLIB) TYPE(*CHAR) LEN(10) 2600 [...]
Answer Question
| March 17, 2012 4:19 PM
CL programming, CL Programming issue, iseries v5r3
I have a backup job which fails to back up the first 4 objects and I believe it’s down to my programmer bad programming. This program:- 2100 PGM PARM(&LEDGER) 2200 DCL VAR(&LEDGER) TYPE(*CHAR) LEN(2) 2300 DCL VAR(&OBJLIB) TYPE(*CHAR) LEN(10) 2400 DCL VAR(&SECULIB) TYPE(*CHAR) LEN(10) 2500 DCL VAR(&JRNLIB) TYPE(*CHAR) LEN(10) 2600 [...]
CL400 & As400
I have a query related to CL programing and As400. Acutally am very new to CL, i need to create a CL program(using commands) which needs to call a menu,where i need to provide proper values according to the application, then its inturn need to store it in a database file(either a As400 cobol or [...]
Answer Question
| October 19, 2011 6:10 AM
AS/400 administration, CL programming, CL/400, Software application development
I have a query related to CL programing and As400. Acutally am very new to CL, i need to create a CL program(using commands) which needs to call a menu,where i need to provide proper values according to the application, then its inturn need to store it in a database file(either a As400 cobol or [...]
Can I write a program in CL to update a record on a database file
Hi, I am not familiar with RPG . Is it possible to write a program in CL to update records in a database file. I have thought about SQL , however I do not have any SQL frontend installed on the AS/400
Answer Question
| March 31, 2012 12:04 PM
AS/400 SQL, CL programming, CL programs, RPG
Hi, I am not familiar with RPG . Is it possible to write a program in CL to update records in a database file. I have thought about SQL , however I do not have any SQL frontend installed on the AS/400
CL Journal Checking Program (AS400)
I would need help to write a CL program that accepts fields: a) From Time b) To Time c) From Date (This should be able to be *CURRENT) d) To Date (This should be able to be *CURRENT) I want to only select updates/deletes/changes to files (i.e. no I/O type access etc) Please suggest. [...]
Answer Question
| June 23, 2011 3:42 PM
AS/400 journaling, CL programming, CL programs, Journal Program
I would need help to write a CL program that accepts fields: a) From Time b) To Time c) From Date (This should be able to be *CURRENT) d) To Date (This should be able to be *CURRENT) I want to only select updates/deletes/changes to files (i.e. no I/O type access etc) Please suggest. [...]
Graphic to text conversion in AS/400
i have a program in that program graphic characters are there how to convert graphical character to as400 characters using cl program only.how is it possible in as400
Answer Question
| May 26, 2011 2:29 PM
AS/400, AS/400 administration, CL Program, CL programming, Conversion functions
i have a program in that program graphic characters are there how to convert graphical character to as400 characters using cl program only.how is it possible in as400
OCL to CL conversion
In OCL you can check a file for activity by using the an If Active command. Is there something similar in CL programming?
Answer Question
| May 20, 2011 5:06 PM
CL programming, iSeries, OCL procedure, V6R1
In OCL you can check a file for activity by using the an If Active command. Is there something similar in CL programming?
Find/Replace/Reformat Text in COBOL or CL400
As part of a rebranding exercise I need to create a program to find/replace variable length text within a file. I know I can do this easily enough via INSPECT/REPLACE (or maybe QCLSCAN in a CL) but has anybody got ideas about how to reformat afterwards (data in the file is stored typically in multiple [...]
Answer Question
| May 9, 2011 10:17 AM
CL programming, CL programs, CL/400, COBOL/400
As part of a rebranding exercise I need to create a program to find/replace variable length text within a file. I know I can do this easily enough via INSPECT/REPLACE (or maybe QCLSCAN in a CL) but has anybody got ideas about how to reformat afterwards (data in the file is stored typically in multiple [...]
Can CL Programming language can have level check error
hi friends in CL Program is it possible that we can get Leve Check Parameter…
Answer Question
| May 10, 2011 5:19 PM
AS/400 Parameters, CL Procedure, CL programming, CLLE, CLP, Level Check
hi friends in CL Program is it possible that we can get Leve Check Parameter…
Declaring the same file twice with two OPENID and reading the same file twice in CL Program
Is it posssible read a db file while declaring twice with openID and reading the same file twice
Answer Question
| March 24, 2011 3:32 AM
AS/400 Database File, CL programming, Database Files
Is it posssible read a db file while declaring twice with openID and reading the same file twice
Capture Return value of Script in CL Program
Hi I am running a script file which returns some value at the end of the script. i.e. the last line of my script is “exit returnVal”. The value is also populating in the returnVal variable correctly but I don’t know how can we capture this return value in my cl program. Could anyone please [...]
Answer Question
| March 9, 2011 8:54 AM
AS/400, CL Program, CL programming, Script errors
Hi I am running a script file which returns some value at the end of the script. i.e. the last line of my script is “exit returnVal”. The value is also populating in the returnVal variable correctly but I don’t know how can we capture this return value in my cl program. Could anyone please [...]
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.
Save IXS CL program
Does anyone out there have a CL program which saves all the objects on an IXS?
Answer Question
| February 7, 2011 7:06 PM
CL Program, CL programming, CLPROGRAM
Does anyone out there have a CL program which saves all the objects on an IXS?
Data Structure in CL
Hi, Upto my knowledge we cant use data structure in cl… Is it Possible? If it Possible then How?
Answer Question
| October 31, 2011 7:29 AM
AS/400 database, CL, CL programming, Data structure
Hi, Upto my knowledge we cant use data structure in cl… Is it Possible? If it Possible then How?
Colored CL Source
How do you insert a hexidecimal value in a CL program to change the color of the source using SEU?
Answer Question
| April 9, 2012 10:00 PM
CL programming, CL programs, Programming Languages, SEU, SEU Editor
How do you insert a hexidecimal value in a CL program to change the color of the source using SEU?
Accessing OUTQs and writers in AS/400
I have been tasked with writing a CL to accept the following incoming parameters USER NAME, OUTQ NAME, LIBRARY NAME, & RETURN CODE.
Answer Question
| December 14, 2010 9:38 PM
AS/400, CL Program, CL programming, OUTQ
I have been tasked with writing a CL to accept the following incoming parameters USER NAME, OUTQ NAME, LIBRARY NAME, & RETURN CODE.
Compiling a CL program
I have a CL pgm in that i used the OVRDSPF command. Now i changed the display file. I’m sure i need to compile the RPG programs that are using the display file. Have a doubt if i need to compile the CL pgm or not?
Answer Question
| November 30, 2010 1:49 PM
AS/400, CL Program, CL programming, CLLE, OVRDSPF
I have a CL pgm in that i used the OVRDSPF command. Now i changed the display file. I’m sure i need to compile the RPG programs that are using the display file. Have a doubt if i need to compile the CL pgm or not?
How to retrieve system name on which I am working in as/400??
how to retrieve system name on which I am working in as/400??
Answer Question
| November 29, 2010 12:06 PM
AS/400 administration, AS/400 system administration, CL programming, CL programs
how to retrieve system name on which I am working in as/400??
iSeries Navigator
how i can find iSeries navigator users. is there any EXIT programe or can use any CL for this.
Answer Question
| November 26, 2010 11:58 AM
AS400 iSeries Navigator, CL Program, CL programming, iSeries Navigator
how i can find iSeries navigator users. is there any EXIT programe or can use any CL for this.





