Prepare Statement in DB2

[abdev]

Hi All,

can i use user defined function in prepare statement?

I am trying following,

sprintf(c_stmt, "INSERT/*+ APPEND */ INTO %s VALUES(?,CHAR_T O_DATE(?,'DD-MON-YYYY')) WITH UR",V_TABLE_NAM E);

EXEC SQL PREPARE ins_stmt FROM :c_stmt;

Error Code: 440 is encountred.

Thanks,
Abhi

[sakumar9]

are you sure that you are getting 440 code from this PREPARE only??

As far as my knowledge is concerned, it should not happen at precompile time atleast. Are you getting this error at run time or compile time??