I was told Program B (that I don't have source to) is using ODBC but I'm
guessing it is JDBC instead.1
An SQL update is executed before the call to Program B and it works without
the library name hardcoded.
When Program B executes, it is the first time the QSQSRVR job is referenced
in the joblog.
After control is returned to my program, the same update that was executed
before the call to Program B is executed again with a different set of
values and it now fails (without the library hardcoded).
Honestly, without the source to Program B so I can duplicate the issue, it
is all speculation and guessing and thus the reason I gave up and hardcoded
the library names.
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of D*B
Sent: Wednesday, December 6, 2017 2:20 AM
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Subject: RE: SQL with connections to multiple databases
... now we are coming closer:
- the programm (you don't have the source) is using SQL CLI and changes the
job to SQL Server mode
- this would only work, if no SQL was used before in the job and commit is
not active!!!
- after getting back controll in your programm:
-- SQL Server mode is still active
-- you are connected to the local database you can't switch back from SQL
Server mode!!!
D*B
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
