1
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
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 [...]
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
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 [...]
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
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) [...]
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
I need to dump the 1st record of a file using runqry is this possible
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
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) [...]
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
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….
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
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, [...]
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
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 [...]
1





