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 [...]

Answer Question   |  April 23, 2012  12:29 PM
CLLE, RUNQRY, Spool file

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 restrict the output file [...]

Answer Question   |  March 31, 2012  5:39 AM
AS/400, AS/400 file specification, RUNQRY, WRKQRY

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) TOSTMF(/temp/tst.csv) +                  MBROPT(*REPLACE) STMFCODPAG(*PCASCII) [...]

Answer Question   |  March 15, 2011  10:05 AM
AS/400, CLLE, CPYTOIMPF, CSV, CSV file format, RUNQRY

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

Answer Question   |  March 31, 2009  5:59 PM
AS/400 printing, AS/400 Query, RUNQRY

OPNQRY
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*/ CPYFRMQRYF FROMOPNID(filename) TOFILE(library/outputfile) + MBROPT(*REPLACE) CRTFILE(*NO) RUNQRY QRY(library/queryname) + QRYFILE((Library/filename) (library/outputfile) CLOF OPNID(filename) DLTOVR FILE(filename) —————————————————————————————– error message:Cause . . . . . : Control language (CL) [...]

Answer Question   |  November 26, 2008  9:03 AM
AS/400 error messages, AS/400 Query, Open Query, OPNQRYF, Run Query, RUNQRY

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

Answer Question   |  February 28, 2011  6:33 AM
Data Description Specifications, DDS, RUNQRY

DB2/400
Hello Guys, 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 command, [...]

Answer Question   |  July 22, 2009  11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY

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 which the input files cannot [...]

Answer Question   |  October 2, 2008  4:06 AM
AS/400 output files, AS/400 Query, Batch files, PRTDFN, RUNQRY