This SELECT statement uses wildcard characters to find all data groups with names that contain an ‘A’. 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 '%A%'The outfile report produced is follows:
DGN SYS SYS
PAYROLL CHICAGO LONDON
ACCTPAY CHICAGO LONDON
ACCTREC CHICAGO LONDON
APP1 CHICAGO LONDON
APP2 CHICAGO LONDON
SUPERAPP CHICAGO LONDON