• Display multiple messages at bottom of screen in AS/400

    I need to display multiple messages at bottom of screen.Is there an alternate way of displaying multiple error messages rather than using message subfile...if so can you give me a simple example

    Ben Rubenstein6,065 pointsBadges:
  • Move values from subfile screen to display file

    I have one display file and subfile. I used load all subfile to load my records in subfile, in that i have one selection filed. My question is if i give "1" in that selection field without pressing "enter" it has to be move values from subfile screen to display file?

    shyedajmal285 pointsBadges:
  • Filter records with a certain value in AS/400 subfile

    did the above steps but its not working… Example:: —————————————– FLD1 FLD2 FLD3 AAA AAAA AAAAA AAA AAAA AAAAA AAA AAAA AAAAA rrn = 3 —————————————– BB ______ _________ I need to filter the records having the value BB, but there are no...

    shyedajmal285 pointsBadges:
  • How to write a CL program to place RUNQRY in the application menu

    My management has asked me to disable the ability of users to access command line from an application by limiting capabilities *YES. I need to write a CL that will allow me to place RUNQRY into the application menu and need help creating the CL program. Can anyone assist?

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

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