DB2 ODBC-Access under z/OS: SYSCAT.TABLES is undefined...

Michael Knigge

DB2 ODBC-Access under z/OS: SYSCAT.TABLES is undefined...
[Posted already on DB2-L, but got no reply so far]
All,


I've tried to use the ODBC-compliant API of DB2 to access a DB2 database.

I was able to create a table using this API (using the SQLExecDirect()
function) but if I try to do a SELECT or DELETE I get the following:

42S02 (-204:834) DSNT408I SQLCODE = -204, ERROR: SYSCAT.TABLES IS AN
UNDEFINED NAME

DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -500 0 0 -1 0 0
SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFE0C' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000'
SQL DIAGNOSTIC INFORMATION ERRLOC=1:13:1


Any idea what is happening here? I'm no DB2 professional but as far I
was able to "google", SYSCAT.** is a view and doesn't exis on DB2 for
z/OS (I'm running V9.1.0).

I'm also wondering why the "ODBC-Driver" DSNAOCLI itself repots version
"DSN0601" using the SQLGetInfo(SQL_DRIVER_VER) function (wasn't the
driver changed since V6?).

I used the IBM Plan "DSNACLI" with no success and also a self
created/bound plan with all the DBRMs also used in the sample JCL
DSN910.SDSNSAMP(DSNTIJCL).


Any ideas anyone?

Thank you very much!

Bye,
Michael

P.S.: If it matters, this is my DSNAOINI:

[COMMON]
MVSDEFAULTSSID=DB9G
;
[DB9G]
MVSATTACHTYPE=CAF
PLANNAME=DSNACLI




--
Mit freundlichen Grüßen

Michael Knigge
Entwicklung


S.E.T. Software GmbH
Lister Straße 15
30163 Hannover

Tel. +49 511/3 97 80-23
Fax +49 511/3 97 80-65
[login to unmask email]

Handelsregister: HRB52778 Amtsgericht Hannover
Geschäftsführer: Till Dammermann, Klaus Stöhr


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html