WRKDG outfile example 2 - 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 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