• 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...

    Rohithsharma8415 pointsBadges:
  • 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 advance...

    Keepsmilin5 pointsBadges:
  • 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              DCLF      ...

    Avrelivs80 pointsBadges:
  • 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...

    Pmh5 pointsBadges:
  • 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.

    JohnsonMumbai1,160 pointsBadges:
  • managing authorization list

    a long time ago, I retrieved a CL from this site to manage authorization list. It displayed all the list to an output file and the CL uses the input file to properly balance the users and objects authority. Does anyone have something similar?

    Getitright10 pointsBadges:
  • 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...

    Haaiderali215 pointsBadges:
  • 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?

    AS400 - Ask the Expert485 pointsBadges:
  • how can we use more than 1 file in CL ?

    Multiple files to used in CL

    Khadar90 pointsBadges:
  • 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 much....

    JennyMack4,280 pointsBadges:
  • 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 to...

    Djsqueeze5 pointsBadges:
  • 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...

    Ninoo35 pointsBadges:
  • 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) the CL pgm that call the query is as follows: PGM...

    NormFeile25 pointsBadges:
  • 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) MONMSG MSGID(CPF9898) EXEC(PARMLCK: SNDUSRMSG + MSG('File MCPARMS in Library...

    Vince0125 pointsBadges:
  • 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 basis. i...

    Lacag100 pointsBadges:
  • AS/400 CL Auto Reply to “Load Next Tape messages”

    Would like to auto reply to this message without amending the system reply list entries, rather just from within the Backup CLP itself.

    Techman965 pointsBadges:
  • ovrdbf doesn’t get deleted with a dltovr

    I've got a cl that copies a PF file to qtemp then I use CRTDUPOBJ to get a LF attached to the qtemp PF file. Then ovrdbf of LF to qtemp/LF with OVRSCOPE(*JOB). After calling 2 programs to update the qtemp/LF I DLTOVR FILE(*ALL) LVL(*JOB). But the override stays doesn't get deleted. I can't figure...

    Mtspudgun45 pointsBadges:
  • CL problem with purge

    The below code was written to automatically purge files once in 2 months.The problem here is that there are months with 30,31 and 28 days so while deletion some files may be left out.Can this be rectified. CHGVAR VAR(&PYD) VALUE(&PYC) CHGVAR VAR(&PMD) VALUE(&PMC) CHGVAR VAR(&PDD) VALUE(&PDC) CHGVAR...

    0 pointsBadges:
  • cl

    DCL &TEXTFILENM *CHAR 40 dcl &curdt *char 6 dcl &curtm *char 6 /* build your CL file name as */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&CURDT) RTVSYSVAL SYSVAL(QTime) RTNVAR(&CURTM) ChgVar &TextFileNm (QDATE *TCAT QTIME *TCAT ‘.TXT’ CPYTOIMPF … To stream file . . . . . . . . . TOSTMF &TextFileNm Am...

    0 pointsBadges:
  • cl

    i have a flat file. data is populated to this file on a daily basis. I need to create a new member every day as and when the flat file is populated.In my cl code I tried using AA *cat &qdate in addpfm and build the name of the file but couldnt do so...As stated earlier i neeed this to purge members...

    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following