Regarding SQL Query in DB2 Stage

purush · Post by **purush** » Thu Mar 15, 2007 12:51 am

Hi,

I was using COLUMN_NAME=? in the sqlquery inthe ODBC stage to make a LookUp. Now the requirement is to use an DB2 stage,if I'm using the same query it is throwing an warning saying incorrect number of parameters.

[IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001

Can anybody help me.

Purush

kumar_s · Post by **kumar_s** » Thu Mar 15, 2007 6:25 am

You need to bind the lookup variable in the reference database. Check the number of key column math the lookup keys.

chulett · Post by **chulett** » Thu Mar 15, 2007 6:50 am

The ODBC stage is very forgiving of binding issues. Others are very picky. For a lookup, you'll need as many ? bind parameters as you have Key fields defined.