Help required in writing a CL program which will monitor QSYSOPR msgq for specific h/w failure msg ID’s and shoot email ?
Hi All – Could any one help me in writing a CL program which will monitor the QSYSOPR msgq for specific h/w failure MSGID’s and shoot email ? Regards, Madhu

Answer Question   |  May 6, 2013  1:04 PM
CL Program, CL/400, OS/400 and iSeries

Can Audit journal and database journal receivers be tampered. ?
Can Audit journal and database journal receivers be tampered.ie. entries modified or deleted by users who have *AUDIT authority alongwith *ALLOBJ authority.

Answer Question   |  September 11, 2012  5:11 PM
CL/400, iSeries, OS/400

Title changing
Hi Group, As per the new assignment i need to change the title from “MQM Application Business” to “ABC”. I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors [...]

Answer Question   |  August 18, 2012  6:02 AM
AS/400, CL/400, DB2/400, DSPF, ILE, Printer files

OPNQRYF in CL
HI I need to filter the records for the particular date range from a file and i need to store it in a temp file.File has date field with length 7,0 centurion date format… Can anyone post the code

Answer Question   |  March 17, 2012  9:09 AM
AS/400, CL/400, OPNQRYF

Question on CL.
Hi Group, I would like to enter input to a CL pgm through console. For example, My CL PGM should take file name as the input from the console and has to display the number of records that are present in that file. Thanks in Advance, MVRK

Answer Question   |  November 16, 2011  1:40 AM
CL/400

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

CL400 parameters
hi, i would like to know how to copy a physical file and its corresponding logical file from one library to another by and these four paramaters &filnam,&fromlib,&tolib,&status should be used ?

Answer Question   |  March 31, 2012  2:03 PM
AS/400, AS/400 Parameters, CL/400

Reading all pfs in production lib. using cl pgm
Dear all, I want to write a cl program under following scenario. 1. Use the command DSPFD to build a list of files existing in LIBA.(which is Prod Lib.) 2. Read the file. 3. Use Command RGZPFM to reorganize Every File that has more than 1000 deleted records Run the job and then DSPFD again [...]

Answer Question   |  March 31, 2012  3:13 AM
CL programs, CL/400, DSPFD, RGZPFM

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

Difference between two strings using CL/400, AS/400, COBOL/400
I am working on a requirement where in I need to find the numerical difference between two character strings. The two strings are 8 character long and can have spaces as values. The two strings are “from” and “to” fields. I will have to find out the last value used and then subtract it from [...]

Answer Question   |  May 2, 2011  10:10 AM
AS/400, CL/400, COBOL/400

CL/400 OPNQRYF returning empty records.
hey there, I got an issue to be corrected. Current CL has and OPNQRYF select which sometimes return blank records. I need to add a condition which should check for such blank query result and by pass a call program. Can you guys help me in giving a hint on which way I can bypass [...]

Answer Question   |  March 25, 2011  12:49 PM
AS/400, AS/400 Records, CL/400, OPNQRYF

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

How to get the “Named-FIRST MBR” in a CL/400 pgm
How to access the “FIRST MBR” of a multi-membered file in a CL/400 program. my scenario ———— I have a multi-membered file called WKSLSP, which has MBRs in the following format either MSPmmddyyn or FDBmmddyyn;(where mmddyy is the JOB-DATE and ‘n’ is the sequence number) like :- FDB100510A  FDB100510B  FDB1005106 MSP1005103  MSP1005105 The Seq. no.(n) [...]

Answer Question   |  October 5, 2010  4:02 PM
AS/400, CL/400, MBR

find physical files with large record counts that are unused
How can I capture the number of records (not file size) for numerous physical files via a cl command in order that I may download the information and find the ones with the largest number of records? I need to free up disk space so I need to find the files that have records but [...]

Answer Question   |  August 20, 2010  3:13 PM
AS/400, AS/400 Database File, CL programming, CL/400, iSeries, Physical Files

Need Help to Write a Code in CL400 to Access All Members of Library in CL400 , and If to find one particular pgm how can i do it ???
Need Help to Write a Code in CL400 to Access All Members of Library in CL400 , and If I want to find one particular pgm thru the same pgm how can i do it ???(FNDSTRPDM) , possiblity to use it and I want to have one sample code does any one knw’s it then [...]

Answer Question   |  July 26, 2010  1:34 PM
AS/400, AS/400 Library, CL/400

Flat file or Physical file in as/400?
How to know whether a file is physical file or flat file in CL/400?.

Answer Question   |  June 23, 2010  2:34 PM
AS/400, AS/400 flat file, CL/400, Flat files, Physical File

AS/400 with RPG/400, ILE, CL/400 Careers in Delhi, Noida ,Gurgaon
I have no  jobs in AS400 when i passed in the year 2008 from year 2008 to 2009 still i am job less

Answer Question   |  January 5, 2010  1:03 PM
AS/400 careers, AS/400 certification, CL/400, ILE, RPG/400

Retriveing massage from submited job in CLP
I have CLP and a cobol program. CL program calls the cobol program in Batch mode by doing SBMJOB. The cobol program processing 1000 records from a database file. If it founds errorneous record in the time of processing, then it stops processing with a system generated error massage and control go backs to CL [...]

Answer Question   |  November 30, 2009  9:22 PM
CL/400, CLP, CLPROGRAM

CL/400 with Looping ?
Hi friends, please help me, I have a looping on this CL ?, this statements below is correct ?, at the first time when the tape is unavailable I receive the e-mail, but on the second time when the tape is available I receive too this same e-mail. [strong]1800 IF COND(&MSGID = 'CPF6760') THEN(DO) [/strong] [...]

Answer Question   |  October 30, 2009  3:25 AM
AS/400 Call stack, CL/400

Delete Spool Files of 30 users (Starting with OP) using Generic Name i.e. OP*
Every 3 moths we are deleting Spool files of users Starting With OP, on iSeries System using the below Program and a Display File. This activity is performed after the Spool Files (Which needs to be deleted) are saved on Tape using BRMS. *************** Beginning of data ************************** PGM                                                                      DCLF       FILE(QGPL/SPOOLED) OPNID(SPOOL)                  DCLF       FILE(QGPL/DLTOLDSPLF) [...]

Answer Question   |  October 28, 2009  7:33 AM
AS/400 Spooled Files, CL/400, i570, Spool files, V5R4M0