Re: Needle in Haystack - Seeking Offending Journal Entry

On Tue, Jan 29, 2019 at 11:17 AM Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>
wrote:

That is probably one of the ones that changed from 7.1 to 7.2. Look on
page 154 of this for the 7.1 format.
http://www.redbooks.ibm.com/redbooks/pdfs/sg247858.pdf

Thanks, Kevin, this works for me:

-- v7.1
select * from table (
QSYS2.Display_Journal
(
'MYJRNLIB', 'MYJRN', -- Journal library and name
'', '', -- Receiver library and name
CAST('2018-01-29 00:00:00.000000' as TIMESTAMP), -- Starting timestamp
CAST(null as DECIMAL(21,0)), -- Starting sequence number
'', -- Journal codes
'', -- Journal entries
'MYTARGLIB','MYFILE','*FILE','*ALL', -- Object library, Object name, Object
type, Object member
'', -- User
'', -- Job
'' -- Program
) ) as x;