Re: Database Trigger Programs

From a sample given me, and from what I have in production, I just declare the
buffer as 32767 and be done with it.  The AS/400 doesn't seem to care in the
least that we are only passing 1000 bytes or whatever.  As long as I don't
try to access outside the "real" buffer no problems occur.

I really don't know what would happen if I tried to use the data outside the
valid buffer, it would probably be gigo (garbage in, garbage out).

Regards,

Jim Langston

Date: Tue, 8 Aug 2000 23:25:37 -0500
From: "William Washington III" <w.washington@iols.net>
Subject: Database Trigger Programs

Hi All!

When creating a trigger program (in RPG/ILE) there is a variable length
section that contains the before and after image of the record that is
changed.  I know how to access them with the offsets.

My question is:  How is the length of the data structure (for the first
parameter of the trigger program) calculated?  I always have to make the
data area ridiculously large, then go into debug mode to see where it ends.
Is there a way to do this programmatically?  Any thoughts are appreciated.

==============================
William Washington III
w.washington3@njiasystems.com
www.njiasystems.com
==============================

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---