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