• print 1st 20 records of the file

    I need to dump the 1st record of a file using runqry is this possible

    crasherrider25 pointsBadges:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • AS/400 RUNQRY: Enter Key

    This may be quiet different to the regular questions. Actually I have coded 3 RUNQRY statements with 3 QRY definitions in a CL program. Program is running fine.Thing is that ,when the control comes before each RUNQRY statement, emulator is prompting for an ENTER key. After pressing the ENTER key....

    HABBIE895 pointsBadges:

    I am using command OVRDBF to override my database physical file suppose "ABC " (file to be overridden) and second physical file let "DEF" (the one with which we are overriding) now I execute this command: OVRDBF FILE(ABC) TOFILE(LIBRARY/DEF). After the execution of this command when I use the...

    Durgesh813375 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:
  • Want Query output into Spool file

    Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the...

    pankaj2r100 pointsBadges:
  • Restrict File Size created by WRKQRY

    How to restrict file size created using RUNQRY ? e.g. Created the query using WRKQRY to join 2 transaction file and output type selected is databasefile. We don't have the exact primary key to relate 2 files, hence we are not sure about the no. of transaction expected from this query. Can we...

    Dharamk5 pointsBadges:
  • Junk characters in CSV conversion through CPYTOIMPF

    Hi, I am sending data from iseries to excel through CPYTOIMPF i've used this command in CLLE, in query output there is a char field value is '01.03.2011' but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY     QRY(ADO150Q) CPYTOIMPF  FROMFILE(ADO150F)...

    Rpgle400tech145 pointsBadges:
  • Hide field which is present in DDS

    I want to hide data of specific field which is present in DDS.The requirement is even in the runqry that field should be hidden....

    Onelonely10 pointsBadges:

    Hi ALL, I am trying to pass to variable to the query select. ----------------------------------------------------------------------------------------------- OVRDBF FILE(filename) SHARE(*YES) OPNQRYF FILE((library/filename) QRYSLT('DATE + *EQ "&SATDYYMD"') /*the variable contains the date*/...

    Secskc25 pointsBadges:
  • Identifying output files in query definitions

    How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in...

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

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