DB2 UDB look up Error
Posted: 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..
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..