RE: jrn

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Yes, better asked on midrange-l.

However, The output from a journal may be a bit cryptic for the 'average
Joe' to read.

It may be where you want to do your maintenance.  Do you want to:
A)  Use a trigger to output history to a nice formatted file.
B)  Use a program to format journal information into a format that the
user can understand?
While the journalling opens up opportunities for commitment control,
restoring, etc; the trigger will make it easier to use standard reporting
tools or traditional programming to analyze the history.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




Buck Calabro <Buck.Calabro@commsoft.net>
Sent by: rpg400-l-admin@midrange.com
10/28/2002 09:05 AM
Please respond to rpg400-l

        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        RE: jrn


>How the journalling differs frm triggers?

Since you asked this in the RPG forum, I will look at the question from an
RPG perspective.  For better answers, try asking in the MIDRANGE-L list at
http://www.midrange.com

A trigger is a way to run a program when a record is added/changed or
deleted.  You have to write the program.  You can make the program
validate
this record against other files and disallow the record if it fails
validation.

acctCode chain codefile
         if    not %found
         ... reject record
         endif

You can also have the program log the change to a file you create.

A journal is a way to log changes to a file without running a program.
  --buck
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.