• How to create ‘n’ number of userprofiles from CL Program

    How to create 'n' number of userprofile from CL Program?

    Lsivabe85 pointsBadges:
  • Export multiple files to Excel using CL

    Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?

    Querys100 pointsBadges:
  • Check each RPG/400 program in batch job

    I have a few programs to submit in batch but I need to check each program sucessfully then I need to call another program.

    Askt265 pointsBadges:
  • How to validate the subfile field in RPG/400 subfile

    I need to validate the subfile field in subfile. For example: user entering the data in subfile; if user enters wrong data in subfile field then i need to show error to user. How do I resolve this?

    Askt265 pointsBadges:
  • Unable to send messages to message subfile in RPGILE program

    I am not able to send the messages to message subfile. I am able to compile my rpgile program sucessfully... please find below displayfile and rpgile code for your reference so please advice. Display file:A R MSGRCD SFL A*%%TS SD 20090407 073131 KSS991U REL-V4R4M0 5769-PW1 A SFLMSGRCD(24) A MSGKEY...

    Askt265 pointsBadges:
  • RPGILE XOP560 error message CEE9901

    I have a rpgile (XOP560) program as below. It compiled sucessfully and while calling the program it is displaying on the screen but once I come out of the screen using f3 I am getting error as below. Message ID . . . . . . : CEE9901 Severity . . . . . . . : 30 Message type . . . . . : Escape Date...

    Askt265 pointsBadges:
  • Change date format in RPGILE

    Can you advise me how to change date format from mmddyyyy to yyyymmdd in rpgile?

    Askt265 pointsBadges:
  • RPG/400 xodstsf

    Below program write a records to xodstsf in two times.... I am not sure what I am missing... can you advise? FWDRPIK CF E WORKSTN FXODSTSF O E DISK FTFL01 UF E K DISK DORDINV S 15A D*ORD S 8A C* *IN03 DOWEQ *OFF C DOW *IN03=*OFF C EXFMT PKSCR C PKLBL CHAIN TFOOD00 C* *IN25 IFEQ *OFF C IF...

    Askt265 pointsBadges:
  • CWBAD1003

    I am getting CWBAD1003 - I need help

    GregFa5 pointsBadges:
  • Can you update physical file through OPNQRYF?

    Can we update physical file through OPNQRYF command in clle (AS400)?Is it possible? OPNQRYF FILE((lib/pf)) OPTION(*UPD) QRYSLT('CDE + *EQ 101 ') KEYFLD((CDE))

    shyedajmal285 pointsBadges:
  • Difference between two OVRDBF approaches

    What is the difference between the below two approaches? OVRDBF FILE(FILE1) SHARE(*YES) SEQONLY(*YES) OPNQRYF (SOME CONDITION) CALL PGM1 DLTOVR FILE(FILE1) CLOF OPNID(FILE1) OVRDBF FILE(FILE1) SHARE(*YES) SEQONLY(*YES) OPNQRYF (SOME CONDITION) CALL PGM1 CLOF OPNID(FILE1) DLTOVR FILE(FILE1)

    rajeshece1,215 pointsBadges:
  • Access a OPNQRYF file using keys

    Is it possible to access a file created by opnqryf in an RPG/400 program using keys? I have defined the KEYFLD parameter but the RPG doesn't find the records when using READE or CHAIN.

    Marg5 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:
  • WRKQRY query

    Hi, I have a CL program which uses WRKQRY to generate a report out of it. Now I have a requirement to change a field which holds Quantity and I want to divide this by 10 to the power of another field say DecFld. ie if Quantity is 359686 and DecFld is 2, I want 359686/10**2 = 3596.86 . Is it...

    RamvishakRamesh2,505 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:
  • How to toggle between two columns in a subfile

    I want to toggle between two columns in a subfile...I'm using following code to condition the fields...however when i display subfile none of the fields are displayed...is there anything else i need to take care of?A #PROCP 8A O 6 22 A 15 DSPATR(ND) A #ORDERP 8A O 6 22 A N15 DSPATR(ND) ---------- C...

    Nutangujar895 pointsBadges:
  • How to remain on same page on Load All Subfile

    I am using Load All Subfile. I used Page Down key and went to 2nd page then on 2nd Page I pressed ENTER Key, then it went back to the first page of subfile. I am using COBOL program to write the subfile. Can anybody tell me how to remain on the same page after pressing ENTER key on Load All...

    Vids295 pointsBadges:
  • Single Page Subfile code

    Hi i have started learning Subfile and i've written a Load All Subfile code to display all the records in a PF. Iit is working fine.But I want to know what else should i include in this code to make it accodring to coding standard. Also i need help in writing the single page Subfile program.So what...

    ITKBHARAT120 pointsBadges:
  • Display only subfile record format

    I am using load all subfile...in that first it will display all records. My question is when i give any condition it has to display empty subfile ie.only subfile record format? plz guide me as early as possible..

    shyedajmal285 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