RE: Where to put a trigger program...

One possible scenario is that you save your data library and restore it to another system. If your trigger programs are in a separate library and you do not restore that trigger library you then have files with trigger definitions but no triggers.


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Jonathan Ball
Sent: Wednesday, March 17, 2021 12:33 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Where to put a trigger program...

I don't know the precise reasoning behind IBM's recommendation, but it could based in part on the fact that if you implement a trigger using the CREATE TRIGGER statement in SQL, the resulting C program will be in the same schema/library as the table/PF.  They might recommend the placement of HLL programs for triggers in the same library for consistency.

See also Brian Parkins's comment about the trigger program being considered a database object.

On 3/17/2021 9:11 AM, Robert Rogerson wrote:

Hi All,

The standard in our shop is that files/tables go in FILLIB and
programs go in PGMLIB.
My requirement is to create a trigger (RPG) program and I'm undecided
as to which library to put the program in.

IBM recommends the data library (
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/dbp/rbaforzah
ftrg.htm) but this goes against our shop standard. The document
suggests the file library but I can't find any documentation as to why
the file library.

Is there any reason I shouldn't/can't use PGMLIB?

Thanks,

Rob

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com