RE: Creating Triggers

["Kandel, Ed" <EKandel@xxxxxxxxxxxxxxxxxxxxx>]

An alternative to SQL...

Look at command:
ADDPFTRG   "Add Physical File Trigger".

Consider the trigger time (Before or After change)
Consider the event (Insert, delete, update, read)

For Shaw's application sounds like you'll want time *AFTER and event *INSERT

You'll need a program to process the event, a trigger program.  
Go here for more info on considerations...:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm

Search  on "Trigger"...

I've done this when API or user exits are not available, work's OK.


You'll need to do this when the file or member is not in use.  Also,
document them; a MAPICS PCM will remove them someday during an update!

Best Regards, 
Ed Kandel 
Senior Programmer/Analyst 
Textron Fluid and Power 
Cone Drive Operations, Traverse City MI 
231 929-8218 

-----Original Message-----
From: Ann Neal [mailto:aneal@xxxxxxxxxxxxxxxxxx] 
Sent: Friday, March 26, 2004 2:04 PM
To: MAPICS ERP System Discussion
Subject: RE: Creating Triggers

Shawn,

We viewed an SQL webinar that said you can create an SQL trigger for a PF
now.  I have not seen the commands to accomplish this.  Maybe do a search on
www.mcpressonline.com  Or search programming list archives on the
www.midrange.com site where this list resides.  If you cannot find an SQL,
we could help with an RPGIV pgm if you have the RPG compiler.  (Today is
pretty hectic, though, would have to be next week.)

Subject: Creating Triggers

How would I create a trigger that was called when an insert was done to
a PF?  Don't I need a trigger program?  I read that this can be created
using SQL.  What I need to do is change a field in a file when a new
record is added.  Thanks for the help.

Shawn Thobe
Network Administrator
Fort Recovery Industries Inc.
419-375-4121

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.