|
midrange.com
Willie, if you know how to code SQL, you can write an SQL trigger which
avoids the need for the sometimes cumbersome buffer. However, you may want
to think about some method of notification other than a simple message. How
about writing to a log file?
Reference this manual from the Rochester ITSO. It has a chapter that
specifically discusses SQL Triggers:
Stored Procedures and Triggers on DB2 Universal Database for iSeries
(SG24-6503-00)
Bob
Bob Slaney/Atlanta/IBM@xxxxx (Lotus Notes)
Internet id: rjslaney@xxxxxxxxxx
Tieline 445-7374 Direct (770)835-7374
FAX tie 445-7579 Direct (770)835-7579
AMS Americas Learning Development
iSeries Course Materials Developer
IBM Corp.
3200 Windy Hill Road
Atlanta, GA 30339
WG07C13
"Willie J. Moore"
<WJMoore@xxxxxxxxx To: "RPG programming on
the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
re.com> cc:
Sent by: Subject: RE: trigger error
help
rpg400-l-bounces@x
idrange.com
08/27/2003 12:21
PM
Please respond to
RPG programming on
the AS400 /
iSeries
Larry,
Thank you for your response. So, I cannot call a CL from a 'trigger'. The
'trigger' program must call an RPG program. Which then in turn sends the
message. This seams like a long way around. I have not done a RPGLE
program. Do you have an example of one that you could send me to look at.
Thanks,
Willie Moore
wjmoore@xxxxxxxxxxxxxxx
-----Original Message-----
From: Jansen, Larry [mailto:ljansen@xxxxxxxxxxxxx]
Sent: Wednesday, August 27, 2003 8:49 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: trigger error help
The program being called has to receive two parameters, the trigger buffer
and the trigger buffer length. The trigger buffer contains control
information and the before and/or after images of the record being
processed. It is variable in length, because it depends on the length of
the record and the trigger event. The trigger buffer length is the length
of the buffer in binary, 9 long with 0 decimal positions. So, you probably
need to have the trigger program written in a higher-level language
(RPGLE),
and include these parameters. Good luck!
Larry Jansen
PREFORMED Line Products
-----Original Message-----
From: Willie J. Moore [mailto:WJMoore@xxxxxxxxxxxxxxx]
Sent: Wednesday, August 27, 2003 11:25 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: trigger error help
I am having trouble with a 'trigger' program. This is my first try. Here
is what I am trying to do.
I have a physical file (slitmtot) that when a record is added a CL program
is called. The CL notifies QC that a record has been entered. Enclosed is
a
copy of the trigger and CL.
I am getting the following error: CPF502B, with an error code of 2 = *after
*insert trigger.
I did CHGJOB LOG(4 0 0 *SECLVL) and ran job. The error was happening at
the
write statement (RMAJOBNO), and that there is a Data Decimal Error. I am
not passing any data to the program that the trigger is calling.
If I remove the trigger, the program runs fine.
Any help would be greatly appreciated.
Willie Moore
California Fine Wire, Co.
TRIGGER:
ADDPFTRG FILE(TESTFILE/RMAJOBNO) TRGTIME(*AFTER) TRGEVENT(*INSERT)
PGM(WJMWORK/RMANOTIFY)
CL:
RMANOTIFY: PGM
DSPPGMMSG MSG('A RECORD HAS BEEN ENTERED') MSGTYPE(*RQS)
ENDPGM:
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/03
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
