Error on DELETE -- whats wrong????

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cuddles
    New Member
    • Apr 2007
    • 21

    Error on DELETE -- whats wrong????

    hi
    im using IBM DB2 version 8

    i have a procedure that should delete an error log table

    DELETE FROM TABLE1.ERR_MSG_ LOG
    WHERE DATE(CRT_S) < (CURRENT DATE - 30 DAYS);

    but i keep getting this error:
    A database manager error occurred.[IBM][JDBC Driver] CLI0604E CallableStateme nt get*** method was called without calling execute. SQLSTATE=S1010
    whats wrong?

    thanks
Working...