Re: Basic Journal functions

On 4/11/2016 12:46 PM, Hoteltravelfundotcom wrote:

HI I am having trouble reading a journal to locate what change was made to
a shipping file.

I have the receiver that I want to see.

But all commands I TRY do not work.
DSPJRN does not find.
WRKJRNRCV does not display the actual data.

The way journals work is the database manager builds up a standard
header that contains items like the date and time the database change
was made, the job making the change and so on. Appended to that is a
single field which contains the actual record that changed. The easiest
way to think of that field in RPG is as a data structure defined
LIKE(TABLENAME). So your data /is/ there, just not in a way you
probably recognise.

Over the years, several community members have written freely available
tools to handle this. Thomas Raddatz has one I use over at
http://www.tools400.de/English/Freeware/Utilities/expjrne-utilities.html
There are certainly several others.