Accessing DB2 using ODBC

asitagrawal · Post by **asitagrawal** » Mon Nov 06, 2006 5:09 am

Hi,

I am trying to access Db2 using the ODBC stage, but I am getting the following error for all the columns.

ODBC_88.DSLink86: DSD.BCIOpenR results of SQLColAttributes(BUSINESS_UNIT) gave MetaData mismatch
COLUMN.TYPE Expected = Char Actual = Unknown

Please tell me a workaround.

I want to use ODBC to access data from Db2 because I want to use 'reference link with multi row result set' property for my reference lookup.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 06, 2006 8:03 am

Get the SQL data types in your job design to match those in the DB2 table (that is, Char of the appropriate size).

chulett · Post by **chulett** » Mon Nov 06, 2006 8:18 am

And make sure you click that 'Get SQL Info' button at least once... it's called something like that, anyway.