print 1st 20 records of the file
I need to dump the 1st record of a file using runqry is this possible
ASKED:
Mar 30, 2009 5:59 PM GMT
UPDATED:
March 31, 2009 8:18:06 AM GMT
RELATED QUESTIONS
- SQL Select
- Passing parameter to Query Manager
- Improve performance for SQL query reading file having milions of recods (AS/400 - SQLRPGLE program)
- cpyfrmimpf
- How to combine 2 linked Excel tables in access 2003 with same field names, using query?
- Primary, Secondary Files processing in RPG
- RRN Max
- need a process to obtain set of records updated/added out of 100million records
- How can I print all picture attachmens attached to a record on an access report
- CPYSPLF with *FIRST option.
Answer Wiki:
QUERY/400 doesn't have a constraint on record numbers.
You could use CYPF to copy the first 20 records to a temporary file
Then use QUERY/400 to report the records.
Phil
Hi,
If you don't need the record formatting from Query, you could just use CPYF to copy the first 20 records to *PRINT.
Regards,
Martin Gilbert.
You could use CYPF to copy the first 20 records to a temporary file
Then use QUERY/400 to report the records.
Phil
Hi,
If you don't need the record formatting from Query, you could just use CPYF to copy the first 20 records to *PRINT.
Regards,
Martin Gilbert.
23,625 pts.
To see other answers submitted to the Answer Wiki View Answer History.
