WRKDG outfile example 3 - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2023
First publish date
1999
ft:lastEdition
2024-05-07
ft:lastPublication
2024-05-07T13:36:02.962500

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