Re: C++, SQLCLI: Making a remote DB2 connection

After I sent this email I found some of my answers (that always seems to
happen). :-)

Do a WRKRDBDIRE and add an entry that has the db name and host particulars
to point to the right system. If you're using STRSQL for testing, then you
do a "CONNECT TO DBNAME USER <user> USING '<password>'"

If in code, create your db connection handle then connect using:
sqlRet = SQLConnect(cv_hSqlDbc, databaseName, SQL_NTS, user, SQL_NTS,
password, SQL_NTS);

I'm setting a default library with my connection (I'm doing this after the
connect; doesn't seem to be a problem)
sqlRet = SQLSetConnectAttr(cv_hSqlDbc, SQL_ATTR_DBC_DEFAULT_LIB,
(SQLPOINTER)library.c_str(), (SQLINTEGER)library.length());

According to the docs, in order for this to work, you have to set system
naming off (do this step before the above SetConnectAttr()).
SQLINTEGER sysnaming = SQL_FALSE;
SQLPOINTER option;
option = &sysnaming;
sqlRet = SQLSetConnectOption(cv_hSqlDbc, SQL_ATTR_DBC_SYS_NAMING,
option);

This seems to work ok, if I have two connections and then 'ask' what their
default library is, the two report back the correct answers (the default
library is different for each connection).

char buf[100];
long olen;
SQLGetConnectAttr(local_db.getConnectionHandle(),
SQL_ATTR_DBC_DEFAULT_LIB, (SQLPOINTER)buf, 100, &olen);
cout << "local lib=" << buf << endl;
SQLGetConnectAttr(remote_db.getConnectionHandle(),
SQL_ATTR_DBC_DEFAULT_LIB, (SQLPOINTER)buf, 100, &olen);
cout << "remote lib=" << buf << endl;

local lib=BOBV
remote lib=DF99328

BUT (with IBM, C++, etc there always seems to be a 'but') - if I do an
unqualified SELECT on a couple of tables, one of the connections is using
the default database of the other connection. I'm trying to figure this out

SQLSelectExecute(local_db, "SELECT * FROM DRIVERS_SNAPSHOT", rows);

SQLSelectExecute(remote_db, "SELECT * FROM UNITS_SNAPSHOT", rows);

In this instance, UNITS_SNAPSHOT is on a remote system and I've set the
default library for it to be DF99328, but the connection information is
trying to use BOBV.

SQLSelectExecute.cpp(67): sqlRet=-1 NativeError=-204 SqlState=42704
Message=UNITS_SNAPSHOT in BOBV type *FILE not found.

This connection should effectively be saying SELECT * FROM
DF99328.UNITS_SNAPSHOT

That's the only thing I need to figure out.