Re: Trigger problems after upgrading to V5R1

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Documented in V5R1, somewhere.

Been discussed in the archives, maybe the rpg archives.

Jon and Susan had an article in some email newsletter but I can't find my
copy, anyone have a link?

Many people refused to use the offsets provided in a trigger program but
instead hardcoded where their data was.  Problem is, that IBM extended the
length of the header data to support blob's, etc in a trigger program.
Thus the users failure to follow the rules bit them in the fanny.  I'd ask
for code, but that should probably go to one of the language specific
lists.

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




"Mike Silvers" <msilvers@hbs-inc.com>
Sent by: midrange-l-admin@midrange.com
04/12/2002 06:59 AM
Please respond to midrange-l


        To:     <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        Trigger problems after upgrading to V5R1


All,

I have a PF trigger that was installed on V4R5.  It was working well.  The
trigger program itself is written in RPG and calls another program.  There
are other triggers on this file also.  The machine was upgraded to V5R1
and
our problems began.  There are other triggers on the file, but they are
from
the package and I have no control over them.  One other thing that has
changed is that the package vendor has added journaling to the file.  I
have
a CL program that checks the status of the trigger and, if it was
detached,
it attaches the trigger.  I learned (the hard way) that the number of
triggers that can be attached to a file has increased.  The program kept
attaching triggers to the file.  At that time the triggers worked.  I
changed the program to create a name for the trigger and replace the
previous trigger on the file.  The trigger shows as attached and enabled,
but it does not fire the program.

Any ideas?

Thanks

Mike

================================
Mike Silvers
AS/400 Senior Programmer/Analyst
AS/400 IBM Certified RPG IV Developer
AS/400 IBM Certified Solutions Expert
Hainey Business Systems
8 E. Canal St
Dover, PA 17315
Branch Office:  (410) 397-8739
Phone:  (800) 932-3380 ext. 237
Fax:  (717) 292-9474
Web: http://www.hbs-inc.com
________________________________
Providing E-Commerce, EDI, AS/400
Development, Java Development,
and related services nationwide.
================================


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.