WRKDG outfile example 3 - assure_mimix - 10.0

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