DataStage job using ODBC stage to access SQL Server table fails with SQL errors if the table name is a subset of a column name.

Troubleshooting

Problem

DataStage job with ODBC driver reading from SQL Server table where the table name is a subset of any column name in that table, the query fails with several errors: DSD.BCIOpenWcall to function SQLPrepare failed, SQLSTATE=S0022, DBMS.CODE=207 SQLSTATE=37000, DBMS.CODE=8180 Statement(s) could not be prepared.

Symptom

DataStage job with ODBC driver reading from SQL Server table fails with errors:
CatDesc..Transformer_2: CatDesc..Cat_Desc_SQL.DSLink8: DSD.BCIOpenWcall to function SQLPrepare failed.
SELECT DTCCATNO,DTCCATDESCFROM CATDESC SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DTCCATNO'. SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DTCCATDESCFROM'. SQLSTATE=37000, DBMS.CODE=8180
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

Error occurs when table name (i.e. CATDESC) is a subset of a column name (i.e. DTCCATDESC).

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1;8.0;11.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere DataStage

Software version:
9.1, 8.7, 8.5, 8.1, 8.0, 11.3

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
254503

Modified date:
25 April 2025

UID

swg21687787

IBM Support

Tips