on DB2/WinNT connected via ODBC a call to SQLPrimaryKeys works fine. if i do the same on OS390 (same tables), the call returns SQL_ERROR but i don't get a ERROR description or state from the CLI driver (state is 00000). other calls like SQLColumns or SQLStatistics work.
any experience on that ?
or any other idea to determine primary keys ?
since i don't have dba rigths i asked the administrator what may be wrong. he told me that i may access systables via an alternate catalog but not sysibm.systables. but how to tell the odbc driver to use an alternate catalog ?