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