This SELECT statement uses a single wildcard character to query the outfile to retrieve and display all of the data group names that start with an ‘A’ and have 0 or more characters following the ‘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 follows:
DGN SYS SYS
ACCTPAY CHICAGO LONDON
ACCTREC CHICAGO LONDON
APP1 CHICAGO LONDON
APP2 CHICAGO LONDON