Re: qsys2.display_journal

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

I'd check two things.
1. Try this format for your timestamp literals:
2025-04-09 14:33:01.236786 2. DSPJRN uses *LIBL for the file object while
Display_Journal specifies the library.

HTH




On Wed, Apr 9, 2025 at 1:08 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Any ideas why the DSPJRN command displays my journal entries yet the
> corresponding SQL statement will not?
>
> This works:
> DSPJRN JRN(ASTJRN/ASTDTA) FILE((OEORHDOH)) RCVRNG(*CURCHAIN)
> FROMTIME('04042025' '134200') TOTIME('04042025' '134300')
>
> This yields no results:
>
> select * from table(qsys2.display_journal('ASTJRN', 'ASTDTA','*CURCHAIN',
> OBJECT_LIBRARY=>'ASTDTA', OBJECT_NAME=>'OEORHDOH',
>         OBJECT_OBJTYPE=> '*FILE', OBJECT_MEMBER=>'*FIRST'))
> where entry_timestamp >= '2025-04-04 13:42:00' and entry_timestamp <=
> '2025-04-04 13:43:00'
>
>
> If I change the Date/Time qualification to match the date in the CURRENT
> journal receiver, the SQL table function yields results.  It's like the
> chaining isn't working.
>
> [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>
> --