RE: Insert using ODBC/system DSN

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Mlpolutta@xxxxxxx
>
> > Can you change your Trigger program to be a CLP, therefore you
> can use CHGLIBL (Change Library List) so that the library list
> will be set up prooperly.  Then call the first RPG
> > program.

> Warning - If this is a "busy" file then the change to a CLP will
> be a performance killer.  CL uses "automatic" storage, which
> means that it is the same as setting on LR in your RPG program
> EVERY TIME, at least as far as it relates to variable storage allocation.

I was thinking this myself.  Instead, you might want to make the trigger
program an RPG program with a first-time flag that calls a CL program to
change the library list the first time.  Then the progam just passes the
trigger information through to the "real" trigger program.

Joe