RE: Insert using ODBC/system DSN

[rob@xxxxxxxxx]

Why not just call an API that changes the library list?

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




"Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/21/2003 11:07 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Insert using ODBC/system DSN


> 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

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