ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from Z/OS.

Erkki Sondergaard

ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from Z/OS.
Got an interesting problem that was escalated to me from 1st level support
that has me stumped as well.

ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from
Z/OS.

Setup:At desktop PC; MS ACCESS 2003 SP2 with IBM DB2 ODBC driver
8.01.13.193 and DB2 V8.2 (fp13) runtime client via DB2 UDB V8.2 (fp13) EE
CONNECT gateway Z/OS DB2 Subsystem.

This works on some machines, but not on others. Even a re-install of the
DB2 runtime client on the problem machines has not solved the problem.
Connections to a DB2 v7 works fine, connections to a DB2 v8 gives a

[IBM][CLI Driver][DB2] SQL0443N Routine "SQLCOLUMNS" (SPECIFIC-name
"SQLCOLUMNS") have returned an SQLSTATE with the errortext "SQLCODE=104
,254 + - AS ORDER", SQLSTATE=38113 (#-443)

Tracing on the host side reveals a -104 on a select that includes 'AS
ORDER'. ORDER is a restricted word in DB2 for Z/OS 8.1 but there should be
no ambigiousness in the given content.

The interesting thing is that we have 2 PC's that shows the problem and 2
others that doesn't. As far as I can tell _everything_ is at the same
levels so where is the problem ??


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

George Burnette

Re: ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from Z/OS.
(in response to Erkki Sondergaard)
If you have not already done so, have someone run the query as a
"passthrough" which basically bypasses anything the jet database engine
might do with the query and just sends the text to the mainfraim to
execute. If it works, I would say you are having a problem with the ms
jet database engine and drivers/dll's. You may want to check into the
verion of mdac you are running on the pc's. It may be upgrading mdac to
a newer release may fix the problem or it may be a newer release was
installed and that caused the problem.

Just some thoughts.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Erkki Sondergaard
Sent: Thursday, December 21, 2006 7:57 AM
To: [login to unmask email]
Subject: [DB2-L] ODBC error using MS ACCESS and ODBC, when selecting DB2
table-data from Z/OS.


Got an interesting problem that was escalated to me from 1st level
support
that has me stumped as well.

ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from
Z/OS.

Setup:At desktop PC; MS ACCESS 2003 SP2 with IBM DB2 ODBC driver
8.01.13.193 and DB2 V8.2 (fp13) runtime client via DB2 UDB V8.2 (fp13)
EE
CONNECT gateway Z/OS DB2 Subsystem.

This works on some machines, but not on others. Even a re-install of the
DB2 runtime client on the problem machines has not solved the problem.
Connections to a DB2 v7 works fine, connections to a DB2 v8 gives a

[IBM][CLI Driver][DB2] SQL0443N Routine "SQLCOLUMNS" (SPECIFIC-name
"SQLCOLUMNS") have returned an SQLSTATE with the errortext "SQLCODE=104
,254 + - AS ORDER", SQLSTATE=38113 (#-443)

Tracing on the host side reveals a -104 on a select that includes 'AS
ORDER'. ORDER is a restricted word in DB2 for Z/OS 8.1 but there should
be
no ambigiousness in the given content.

The interesting thing is that we have 2 PC's that shows the problem and
2
others that doesn't. As far as I can tell _everything_ is at the same
levels so where is the problem ??


------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written
agreement or government initiative expressly permitting the use of
e-mail
for such purpose.
------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bill Brown

Re: ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from Z/OS.
(in response to George Burnette)
we also ran intothis problem. you need to contact ibm. there is a fix for
this. dont have the number, sorry.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm