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, ENTRYTSPThe 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