Re: Insert using ODBC/system DSN

Thanks for your help it worked great.   I just tried one more thing and
deleted all obdc DSN entries on my desk top then reconfigured and the the
library got picked up.  Thats what happens when you have several DSN entries
and 2 hours of sleep.     Thanks for your help
<Todd.Sabella@xxxxxxxxxx> wrote in message
news:76D0455392610F4D86001CF7B038D67A010F6F6D@xxxxxxxxxxxxxxxxxxxxxx
>
> 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.
>
>
> _______________________________________________
> 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.
>
>