Wrong number of parameters. SQLSTATE=07001
Posted: Sat Jan 24, 2004 5:18 am
I get the following error message when I do a comparision on two date fields
[IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
The user defined query in the UDB Stage is:
SELECT A,B,C,CREAT_D FROM DB2PROD.ALPHA WHERE CREATE_D > ? ;
My job runs if I replace the '>' with '='. It aborts when the operator is either '<' or '>'
I tried changing the datatype to varchar of length 10 but it didnt help. The date format is yyyy-mm-dd
Any suggestions ?
[IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
The user defined query in the UDB Stage is:
SELECT A,B,C,CREAT_D FROM DB2PROD.ALPHA WHERE CREATE_D > ? ;
My job runs if I replace the '>' with '='. It aborts when the operator is either '<' or '>'
I tried changing the datatype to varchar of length 10 but it didnt help. The date format is yyyy-mm-dd
Any suggestions ?