Issue with hyphens in DB2 connector stage input SQL

gopalvemu · Post by **gopalvemu** » Fri Dec 27, 2013 10:36 am

Hi,

We have a parallel job that is reading from DB2 database using DB2 connector stage. The select SQL defined in the connector stage has a where clause for which we pass values during run time. The values that are being passed are row_ids and are in the format 1-XXXXX. For example, '1-CMIU65'

The issue we are having is, when we pass values in this format, DB2 connector stage ignores the 1- and takes in only XXXXX part of the value and gives the following error:

SQLExecute reported: SQLSTATE = 42S22: Native Error Code = -206: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "CMIU65" is not valid in the context where it is used. SQLSTATE=42703 (CC_DB2DBStatement::executeSelect, file CC_DB2DBStatement.cpp, line 1,959)

Passing the same values to a DB2 API stage works without any issues.

Wondering if anybody had any ideas to fix this.

Thanks for your help.

chulett · Post by **chulett** » Fri Dec 27, 2013 10:38 am

What version of DataStage? Have you checked to see if there are any patches / fixpacks that address this issue?

gopalvemu · Post by **gopalvemu** » Fri Dec 27, 2013 10:44 am

Hi.. The version is DataStage 8.7 Fixpack 2. I tried looking, but did not find any patches or fixpacks that address this issue.