This SELECT statement uses wildcard characters to query the outfile for all data group names that are in the outfile. The records are listed in record arrival order. The statement would be entered as follows:
SELECT DGDFN, DGSYS1, DGSYS2 FROM library/filename WHERE DGDFN like '%%'The outfile report produced follows:
DGN SYS SYS
INVENTORY CHICAGO LONDON
PAYROLL CHICAGO LONDON
ACCTPAY CHICAGO LONDON
ORDERS CHICAGO LONDON
ACCTREC CHICAGO LONDON
APP1 CHICAGO LONDON
APP2 CHICAGO LONDON
SUPERAPP CHICAGO LONDON