|
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. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.