RE: Insert using ODBC/system DSN

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.

-----Original Message-----
From: news.software.ibm.com [mailto:Tom.wheeler@xxxxxxx]
Sent: Monday, April 21, 2003 10:25 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Insert using ODBC/system DSN


I am under the gun to get this to work...



I have a fileA that has a trigger that calls rpg program.  When I insert a
record into fileA the trigger calls a rpg program that writes another record
to fileB.   In the RPG program it does a call to another rpg program in a
different library then the trigger program is in.  I tried to add the
library to the odbc/dsn description library list but that did not work.  The
user profile the odbc uses calls a initial program the signs itself off so
now one can sign in using it adding it there will not work.  I do not want
to modify the rpg because it is a third party program.



.....  Please any help would be appreciated.







_______________________________________________
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.