DSPPTF LICPGM(5761SS1) SELECT(SI39822)
Displaying a journal entry from a GUI interface today either requires using APIs or writing the journal entries to an outfile. The APIs are labor intensive and the outfile is somewhat restrictive and slower since a copy of the data required.
Download the SI39822 PTF and enjoy
Select all entries from the *CURCHAIN of journal mjatst/qsqjrn whose time is equal or after 2010-03-31-19:01.15 with user MJA.
Displaying a journal entry from a GUI interface today either requires using APIs or writing the journal entries to an outfile. The APIs are labor intensive and the outfile is somewhat restrictive and slower since a copy of the data required.
Download the SI39822 PTF and enjoy
Code:
select * from table (Display_Journal( 'MJATST', 'QSQJRN', -- Journal library and name '', '', -- Receiver library and name CAST(null as TIMESTAMP), -- Starting timestamp CAST(null as DECIMAL(21,0)), -- Starting sequence number '', -- Journal codes '', -- Journal entries '','','','', -- Object library, Object name, Object type, Object member '', -- User '', -- Job '' -- Program ) ) as x;
Code:
select * from table (mjatst.Display_Journal( 'MJATST', 'QSQJRN', -- Journal library and name ' ','*CURCHAIN', -- Receiver library and name CAST('2010-03-30-19.01.15.000000' as TIMESTAMP), -- Starting timestamp CAST(null as DECIMAL(21,0)), -- Starting sequence number '', -- Journal codes '', -- Journal entries '','','','', -- Object library, Object name, Object type, Object member 'MJA', -- User '', -- Job '' -- Program ) ) as x;
Comment