DB2 UDB look up Error

tanaya.deshpande@tieto.co · Wed Mar 23, 2011 2:03 am

HI

I am using DB2UDB as a look up (Not the enterprise but the plain one)
in that I am using Enter custom sql statement as a query option ..and Iam getting following error..

D_Product,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'SELECT D_Product.Product_ID,D_Product.ProductName,D_Product.ProductCategory,D_Product.ManufacturingUnit,D_Product.Vendor FROM D_Product WHERE D_Product.Product_ID=?'. See following DB2 message for details.

but there are no following errors ..those are for other stages ...the previous error is

D_Product,0: Failure during execution of operator logic.

can any one explain..

tanaya.deshpande@tieto.co · Wed Mar 23, 2011 2:04 am

I am getting this error for any query type...

abhilashnair · Post by **abhilashnair** » Wed Mar 23, 2011 3:03 am

tanaya.deshpande@tieto.co wrote:I am getting this error for any query type...

Check the query inside the stage. The WHERE condition seems to be incomplete. Try running the query directly on database and verify that rows are being returned. Then run the DS job

antonyraj.deva · Post by **antonyraj.deva** » Wed Mar 23, 2011 3:43 am

DB2 will throw a fatal error if you specify unsigned type for Integer or Bigint or Tinyint datatypes. Also it is worth checking if the column names, data types and length are correctly mentioned.

Post the complete query which resulted in this error.

tanaya.deshpande@tieto.co · Wed Mar 23, 2011 5:03 am

Yes my problem is solved the query was wrong ...