Re: Information available when a db2 trigger fires off/calls an rpg program.

SELECT journal_code, journal_entry_type, object,
x.current_user, job_name, job_user, job_number,
program_name, program_library,
remote_port, remote_address, system_name,
X.*
FROM TABLE (QSYS2.Display_Journal(
OBJECT_NAME => 'IIM',
OBJECT_LIBRARY => 'ERPLXF',
OBJECT_OBJTYPE => '*FILE',
JOURNAL_LIBRARY => '#MXJRN',
JOURNAL_NAME => 'BPCS_ALL',
STARTING_TIMESTAMP => TIMESTAMP(current date - 30 days),
STARTING_RECEIVER_NAME => '*CURCHAIN'
) ) AS X
;
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DISPLAY_JOURNAL%20(easier%20searches%20of%20Audit%20Journal)


Rob Berendt