• Reading records from a file (No Key Field) in reverse order through CL.

    Hi, I just want to know how to read a PF in reverse order through CL. File has no key field. I am trying this using OPNQRYF but I'm unable to get. Kindly let me know the code. Thanks

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

    22917510 pointsBadges:
  • Compile all dependent logical files at once

    I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Logical Files , which are depended on PF1. I am writing code...

    Khadar90 pointsBadges:
  • Use CVTDAT to convert date formats

    I have taken 2 parameters(like date and date types). A. If suppose date type is j, now i want to convert date to *MDY format B. If date type is M,now i want to convert date to *JUL format C, sending a Program message with the value of converted date. (With use of CVTDAT in cl coding.) Can anyone...

    Thara15 pointsBadges:
  • Write record value onto DSPF using OVRDBF

    In a single CL/400 program, is it possible to declare physical file File1, then read a record and later writing the record value onto the DSPF using OVRDBF with in a same CLP?

    Kar425 pointsBadges:
  • What is the lifecycle of RPG/400 and CL/400?

    In an interview, interviewer asked me this question: Can anybody tell me what is RPG and CL lifecycle in a real-time scenario?

    Ben Rubenstein3,925 pointsBadges:
  • OPNQRYF problem CPF9899

    DCLF FILE(LIBRARY/DISPLAY) START: SNDRCVF RCDFMT(REC) WAIT(*YES) IF COND(&IN03 *EQ '1') THEN(DO) GOTO CMDLBL(END) ENDDO IF COND(&ENQQUA1 *EQ ' ') THEN(DO) GOTO CMDLBL(START) ENDDO IF COND(&ENQQUA1 *NE *BLANKS) THEN(DO) OPNQRYF FILE((SARKNS/ENQP002)) OPTION(*ALL) + QRYSLT('&ENQQUA...

    Khadar90 pointsBadges:
  • OPNQRYF query not working to filter pfdiv records

    I have 4-fileds on Display File like frdiv(zoned),todiv(zoned),frpr(char),topr(char). All the fields are of size 2 only. I am using a "OPNQRYF" to filter the records from a Physical file (pfdiv), it contains 1,25,000 records . Through this openqryf all the selected records I will copy to a file...

    Khadar90 pointsBadges:
  • OPNQRYF error in QRYSLT

    PGM DCLF FILE(LIBRARY/DISPLAY) START: SNDRCVF RCDFMT(REC) WAIT(*YES) IF COND(&IN03 *EQ '1') THEN(DO) GOTO CMDLBL(END) ENDDO IF COND(&ENQQUA1 *EQ ' ') THEN(DO) GOTO CMDLBL(START) ENDDO IF COND(&ENQQUA1 *NE *BLANKS) THEN(DO) OPNQRYF FILE((SARKNS/ENQP002)) OPTION(*ALL) +...

    Khadar90 pointsBadges:
  • QCMDEXC error

    Hi, I have built a small application using CL to convert date to required format. When I want to accomplish the same from RPGLE program with a display file to input date I wanted to call CVTDAT command from the RPG program. But I am getting error saying this command can't be issued in this set...is...

    ten20081,150 pointsBadges:
  • ALCOBJ scope

    I want to allocate the data area by using ALCOBJ command and I am confused about the in selecting the scope. Can anyone explain me about the difference between JOB scope and THREAD scope in details?

    frmdeva365 pointsBadges:
  • 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

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

    JohnsonMumbai1,160 pointsBadges:
  • 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...

    mvrkrishna525 pointsBadges:
  • Read backword in CL/400

    How to read backword a physical file in CL400.

    Bdchow5 pointsBadges:
  • 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 to check...

    6r1,485 pointsBadges:
  • 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 ?

    Srfnhmd125 pointsBadges:
  • 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

    22917510 pointsBadges:
  • CPYSPLF from one profile to another

    Is there a command thru which we can copy the spool file from one profile to other?

    PRIYAS40 pointsBadges:
  • 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

    mvrkrishna525 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