RUNQRY

print 1st 20 records of the file

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

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

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

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