Journal Info: SQL vs CL

[MFisher]

If I run this, I get results in 5-10 seconds

DSPJRN JRN(LXJRNLIB/LXJRN) FILE((LXPRDUSRF/MRPIPR00)) RCVRNG(*CURCHAIN)
FROMTIME('02/05/23') JRNCDE((R)) ENTTYP(PT) ​

I think this is equivalent, but I could go to lunch and it would still be running when I get back. Am I doing something wrong in the SQL version ?

SELECT * FROM TABLE (QSYS2.Display_Journal('LXJRNLIB', 'LXJRN', JOURNAL_CODES => 'R',
STARTING_RECEIVER_NAME => '*CURCHAIN',
OBJECT_OBJTYPE=>'*FILE',
OBJECT_LIBRARY=>'LXPRDUSRF',
OBJECT_NAME=>'MRPIPR00',
OBJECT_MEMBER=>'*ALL'
) ) AS X
WHERE entry_timestamp > CURRENT TIMESTAMP - 24 HOUR
and journal_entry_type in ( 'PT')
ORDER BY entry_timestamp DESC