Cannot find ODBC function <SQLBindCol> in <>.

dataservices administration
1

I am getting this error:

Cannot find ODBC function in <>. Notify Customer Support.

When I attempt to execute my job. The job contains a single data flow which has a DB2 source table (on z/os, via DB2 connect), a query transform (all 1 to 1 column maps except for one hardcoded value), and an Oracle 10g target table. I am able to view the schema and data values in the source table from within DI. I have tried deleting and reimporting the table, shutting and restarting DI, and a reboot.

I have already notified customer support, with no response as yet (28 hours and counting). Has anyone seen errors similar to this who could point me in the right direction? I looked in the error description file but it was not much help. I do know what a SQLBindCol basically does (enumerate columns to be retrieved from table), but I don’t know anything about the DI implementation. Any ideas?

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)

2

Any uncommon datatypes :confused:

Werner Daehn :de: (BOB member since 2004-12-17)

3

Nope. All Varchar.

eepjr24 :us: (BOB member since 2005-09-16)

4

got it. It is the hardcoded column. DI adds that for some odd reasons to the select statement like “select col1, col2, 499 from table” and mainframe cannot deal with it.

Checkout yourself, go to the menu validate, show optimized SQL.

To avoid, you can either put a function around that does not do anything but cannot be pushed down for DB2.

But in case of mainframe, it might be even better to strictly control what is pushed down or not by placing a MAP_OPERATION Transform as a blocking operation. PLay with that yourself and keep looking to “show optimized SQL” (but save DF before as the display does not get refreshed upon save)

Werner Daehn :de: (BOB member since 2004-12-17)