Re: Display Journal data

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

There are undocumented things to do such things.  There are exceptions
where these fall flat on their face.  Namely if you have a tendency to
A/C/D columns in your tables then columns may not line up between.

SELECT * FROM TABLE (
                 QSYS2.DISPLAY_JOURNAL( '#MXJRN', 'BPCS_ALL',
                 OBJECT_LIBRARY *=>* 'ERPLXF', OBJECT_NAME *=>* 'IIM',
                 OBJECT_OBJTYPE *=>* '*FILE', OBJECT_MEMBER *=>* 'IIM'

*--, STARTING_RECEIVER_NAME => '*CURCHAIN'*                 )) AS JT;


*-- sample SEQUENCE_NUMBER returned:  2640181786*
*-- sample RECEIVER_NAME returned:  ALLRCV7462*
*-- sample JOURNAL_CODE returned:  R*call qsys2.display_journal_entry_info(
*2*,
*--not sure what 2 means*'#MXJRN',
'BPCS_ALL',
*2640181786*,
*-- SEQUENCE_NUMBER*'#MXJRN',
*-- RECEIVER_LIBRARY*'ALLRCV7462',
*-- RECEIVER_NAME*'R'
*-- JOURNAL_CODE*);

On Fri, Feb 20, 2026 at 2:17 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Probably been asked and answered, but I couldn't find it.
>
> Is there a way to get QSYS2.DISPLAY_JOURNAL to display the record data the
> same way DSPJRN does?
>
> Had a situation where it would have been very useful.
>
> TIA
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.