WRKDG outfile example 4 - 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 selects all records that have a data group name containing an ‘A’. These records are listed in data group name order with all duplicate data group names listed by the time the entry was placed in the outfile. All records for a data group are listed together in ascending time sequence. Additionally, the time stamp that the entry was placed in the file and the current top sequence number of the object journal are also listed with the entry. The statement would be entered as follows:

SELECT DGDFN, DGSYS1, DGSYS2, ENTRYTSP, CUROBJSEQ, FROM library/filename WHERE DGDFN like '%A%' ORDER BY DGDFN, DGSYS1, DGSYS2, ENTRYTSP

The outfile report produced follows:

DGN         SYS       SYS       ENTRYTSP                       SEQN  
PAYROLL     CHICAGO   LONDON    2001-02-06-11.09.59.842000     29,034,877
ACCTPAY     CHICAGO   LONDON    2001-02-06-11.24.05.851000     29,035,093
ACCTREC     CHICAGO   LONDON    2001-02-06-11.09.59.842000     29,034,879
APP1        CHICAGO   LONDON    2001-02-06-11.24.05.851000     29,035,095
APP2        CHICAGO   LONDON    2001-02-06-14.24.49.793000     29,051,130
SUPERAPP    CHICAGO   LONDON    2001-02-06-11.09.59.842000              0