HI all
I am executing the below query in Db2 usin prepared statement


select days(current date) - days (date( ? )) from sysibm.sysdummy1 ;

when i passed the parameter as string it is not working

but when i execute the same query in command line processor its working fine.

select days(current date) - days (date('2006-12-01')) from sysibm.sysdummy1 ;

the above query works fine but it doesn't when i used the prepared statement.

Can any one help me out.