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..
DB2 UDB look up Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
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.
Post the complete query which resulted in this error.
TONY
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm