home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Hall of Fame
/
HallofFameCDROM.cdr
/
3x400
/
qryf.lzh
/
QRYF.DOC
< prev
next >
Wrap
Text File
|
1987-09-04
|
2KB
|
43 lines
QRYF (Query report for a file) Command
The QRYF command can be used to create a temporary query program in
QTEMP and list a file.
= *LIBL =========
QRYF----FILE file-name---< >-----------------------
- .library-name -
>-FORMAT--format-name------TITLE--'report-title'-(32 char max)-------
(1) = *LIST ==========
>-FIELDS--field-name-------USE-< - *SUM------------ >----------------
- *SBTx (x=1-9) --
(3) (2)
= *DFT ========== = *DFT ============
>-EDIT--< >------SPACE--< >----
RPG edit code---- - 1-9 -------------
(4)
= *DFT =====================
>-TITLE---<-- 'column title' or *BLANK -->---------------------------
│ │
-- 3 maximum ---------- Required
---------------------------------------------------------------------
(5) Optional
= *FIRST========
>---MEMBER-< - *OPNQRYF------ >-----
- member-name---
(1) Up to 10 fields may be specified
(2) SBTx indicates that subtotals are to be taken when this field
changes, the x is a number between 1 and 9 which indicates the sort
order with 1 being the highest.
(3) *DFT indicates to use the query utility default
(4) This is the number of spaces to insert before the column.
(5) When MEMBER is *OPNQRYF the reformat utility is used to copy the
output from the OPNQRYF to a temporary file in QTEMP so that the
generated query program can read it.