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_TO_DATE(?,'DD-MON-YYYY')) WITH UR",V_TABLE_NAME);

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??

Prepare Statement in DB2

re: Prepare Statement in DB2

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about