By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,608 Members | 2,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,608 IT Pros & Developers. It's quick & easy.

Error on DELETE -- whats wrong????

P: 21
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 CallableStatement get*** method was called without calling execute. SQLSTATE=S1010
whats wrong?

thanks
Sep 18 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.