Issue with hyphens in DB2 connector stage input SQL
Posted: 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.
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.