Hello – I’m developing an app that needs to copy data from one database to another database. I have two DB2 LUW instances DB2COPY1 (DB2 / SQLLIB) and DB2COPY3 (DB2_02 / SQLLIB_02) running on my laptop. They both have one database, IAINT001 on DB2COPY1 and IATEST01 on DB2COPY3. Both of them are cataloged to their respective instance and connect fine in ODBC.
In my Rocket COBOL program, if I connect to database IAINT001 first, then connect reset, then connect to database IATEST01, the connection to IATEST01 fails with SQLCODE -19703, as below.
However, if I switch the sequence of the databases and connect to database IATEST01 first, it works. After the connect reset, the connect to database IAINT001 fails with SQLCODE -19703, as below, just like database IATEST01 failed above.
SQLCODE -19703 seems pretty generic.
Anyone know what I’m doing wrong?....
