Re: View row data in QSYS2.DISPLAY_JOURNAL

Can you create a UDTF which expands that UDTF?
I'm thinking of something which utilizes RPG or something to bounce that
blob against some externally defined data structures to break them down
into their individual columns.

I know nothing about XML but I saw a recent post on this list about using
XML within SQL to substring out data that just really opened my eyes. I
wonder if there's some capability in that?

You could create an RFE for this. I can see it as being really popular.

SELECT x.*
FROM table(
DISPLAY_JOURNAL( 'myLibrary', 'myJournal', '', '', CAST(null as
TIMESTAMP), CAST(null as DECIMAL(21,0)), '', '', '', '', '', '', '', '',
'')
) as X
lateral O.*
FROM table(
Blob_To_Columns(Entry_Data, StartingPositionOldValue, LengthOfRow)) as O
lateral N.*
FROM table(
Blob_To_Columns(Entry_Data, StartingPositionNewValue, LengthOfRow)) as N


Rob Berendt