COBOL/400 – Time stamp
Hi, could anyone please advice me how to use time stamp in COBOL/400?
Answer Question
| May 15, 2013 4:58 AM
AS/400, CLLE, COBOL
Hi, could anyone please advice me how to use time stamp in COBOL/400?
Trigger
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question
| May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
QBatch subsystem Monitoring
Hi Guys, I have requirements, I need the Job details like( Job Number, name , user) of any job as soon as they entered in Qbatch Subsystem. Do we have any API or some commands to fetch that… The only solution i m thinking is of take the *Print of WRKACTJOB command for QBATCH every [...]
Answer Question
| March 1, 2013 8:01 PM
AS/400, CLLE, iSeries, iSeries AS/400, QBATCH, RPGLE, Subsystems
Hi Guys, I have requirements, I need the Job details like( Job Number, name , user) of any job as soon as they entered in Qbatch Subsystem. Do we have any API or some commands to fetch that… The only solution i m thinking is of take the *Print of WRKACTJOB command for QBATCH every [...]
Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?
Hello All, I ran into a roadblock writing a new purge process for my company. Here’s the situation: I have 3 files that hold EDI Data that I need to purge: FILEA – Record Format FILEAR FILEB – Record Format FILEBR FILEC – Record Format FILECR All of the above files have the same record [...]
Answer Question
| February 21, 2013 11:48 PM
AS/400, CLLE, OVRDBF, RPGLE
Hello All, I ran into a roadblock writing a new purge process for my company. Here’s the situation: I have 3 files that hold EDI Data that I need to purge: FILEA – Record Format FILEAR FILEB – Record Format FILEBR FILEC – Record Format FILECR All of the above files have the same record [...]
Retreving source file names of a library
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also. [...]
Answer Question
| October 8, 2012 9:20 AM
CLLE, iSeries V5R4MO
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also. [...]
Problems using QTEMP in a CLLE
I have a CLLE program. I’m creating a file in QTEMP. Then I do an OVRDBF to the QTEMP file. Then I call an RPGLE to output records to the QTEMP file. The records are actually going to a file in my library list, not QTEMP. How do I get a CLLE to use my [...]
Answer Question
| July 5, 2012 6:17 PM
CLLE, OVRDBF, QTEMP
I have a CLLE program. I’m creating a file in QTEMP. Then I do an OVRDBF to the QTEMP file. Then I call an RPGLE to output records to the QTEMP file. The records are actually going to a file in my library list, not QTEMP. How do I get a CLLE to use my [...]
AS400 menu options help creation
It is DSPF with subfile that includes: Option# (up to 999, alpha-numeric) and option description(up to 30 chars.). Some options can start the other menu (nested). Thank you. yuriy44
Answer Question
| May 8, 2012 1:59 PM
AS/400, AS400/RPG, CLLE
It is DSPF with subfile that includes: Option# (up to 999, alpha-numeric) and option description(up to 30 chars.). Some options can start the other menu (nested). Thank you. yuriy44
Want Query output into Spool file
Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the [...]
Answer Question
| April 23, 2012 12:29 PM
CLLE, RUNQRY, Spool file
Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the [...]
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 Data Structure Compiler Crash in CLLE
Hi, I had a 443 byte DS defined in CL, as input Parm and with subfields, in CLLE the compiler crashed (V7R1) and in CLP compiled fine. Anyone else come across this?
Answer Question
| February 27, 2012 12:46 PM
AS/400 V7R1, CL data structure, CLLE
Hi, I had a 443 byte DS defined in CL, as input Parm and with subfields, in CLLE the compiler crashed (V7R1) and in CLP compiled fine. Anyone else come across this?
Suppress/trailing blanks in a string variable through CLLE
Is there possibilities to suppress leading and trailing blanks in a string variable through CLLE??
Answer Question
| March 19, 2012 12:34 PM
AS/400, AS400 RPGLE, CLLE
Is there possibilities to suppress leading and trailing blanks in a string variable through CLLE??
As400/CLLE issue
can we load subfile through clle?
Answer Question
| March 17, 2012 7:45 AM
AS400 iseries, CLLE
can we load subfile through clle?
As400/CLLE issue
i made a PGM for read as well as write the record in DSPF but my PGM doesn`t read that PF it not showing any error .. it shows Blank value in varible. PGM [...]
Answer Question
| March 17, 2012 7:18 AM
as/400 data, CLLE, PGM
i made a PGM for read as well as write the record in DSPF but my PGM doesn`t read that PF it not showing any error .. it shows Blank value in varible. PGM [...]
Want to make a utility to search string.
[h3 class="groups"> Hi,[/h3] [h3 class="groups">I want to make a utility in AS400 to search a string (Such as file name/PGM name) in my current Library and in all Source physical files if found show PGM and all related files. Like I do trough find string Command. [/h3] It would be also help ful you can [...]
Answer Question
| March 17, 2012 3:09 PM
CL, CLLE, RPG, RPGLE
[h3 class="groups"> Hi,[/h3] [h3 class="groups">I want to make a utility in AS400 to search a string (Such as file name/PGM name) in my current Library and in all Source physical files if found show PGM and all related files. Like I do trough find string Command. [/h3] It would be also help ful you can [...]
how to set lower and higher records in CLLE
i want to set lower and higher records value using CLLE program…. or read first record and last record in cl….
Answer Question
| February 28, 2012 11:39 AM
as400 v5r3, CLLE, CLLE - Opnqryf
i want to set lower and higher records value using CLLE program…. or read first record and last record in cl….
EMLSTMF – Email Address
Hi, I have used SNDDST seamlessly to send .csv files, collecting the users email address via a DSPDIRE (output to a file in QTEMP). My question is : I want to use EMLSTMF instead but how can I access the email address from DSPDIRE ? Many thanks.
Answer Question
| March 17, 2012 11:45 AM
AS/400, CLLE, RPGLE
Hi, I have used SNDDST seamlessly to send .csv files, collecting the users email address via a DSPDIRE (output to a file in QTEMP). My question is : I want to use EMLSTMF instead but how can I access the email address from DSPDIRE ? Many thanks.
Passing parameters RPG-CL-RPG
I am trying to modify an intermediate CLLE program to submit itself to batch. The calling program (ILE RPG) passes a parameter as a character field with a number in it. The CL program receives it as a numeric field and then calls another RPG program and passes that parameter. The final RPG program receives [...]
Answer Question
| March 19, 2012 7:47 PM
CLLE, Parameters, RPG ILE
I am trying to modify an intermediate CLLE program to submit itself to batch. The calling program (ILE RPG) passes a parameter as a character field with a number in it. The CL program receives it as a numeric field and then calls another RPG program and passes that parameter. The final RPG program receives [...]
Default Font Name in AS/400
Hi All, Can Anyone tell me that which Font we use in As400, i mean default font nmae for As400. Thanks
Answer Question
| June 9, 2011 9:04 AM
AS/400, AS/400 fonts, AS/400 printing, CLLE, RPGLE
Hi All, Can Anyone tell me that which Font we use in As400, i mean default font nmae for As400. Thanks
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…
Source name and location for RPGLE
I want to find out the source name and location for all objects within a library – The source types are RPGLE and CLLE. Kindof like we use the DSPOBJD for RPG sources. Thanks.
Answer Question
| May 2, 2011 8:38 AM
CLLE, DSPOBJD, RPG Source, RPGLE, Source Code Analysis
I want to find out the source name and location for all objects within a library – The source types are RPGLE and CLLE. Kindof like we use the DSPOBJD for RPG sources. Thanks.





