DSXchange

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.

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

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