FW: DB2 Trigger Problems at V5R1

["Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx>]

Here is a response that I got from Paul that compliments what I sent out for
code.

Aaron Bartell


-----Original Message-----
From: paul.nicolay@pandora.be [mailto:paul.nicolay@pandora.be]
Sent: Thursday, June 06, 2002 4:33 AM
To: ALBartell@taylorcorp.com
Subject: RE: DB2 Trigger Problems at V5R1


Hi,

Since my mail account at Merck is removed... please find my comments below.
Also feel free to send this to the list for the benefit of everybody.

Aaron, while your approach works fine as well, it has a small drawback.  The
problem is that you need to define your WPPARM1 datastructure big enough
(and this can even go beyond the limits of RPG when you have really big file
images) to hold the required fileimages, or otherwise your %SUBST might fail
for out-of-range issues.

If you however define your FileImage as a based on field, then you can set
the pointer to the %Addr(WPPARM1) + the required offset field.  This way you
don't need to specify the length for the WPPARM1 DS, and in addition it is
much faster as it doesn't have to copy file images.

Kind regards,
Paul