Hi!!!

I have a problem. We have a java applications that when execute a delete statement get a SQLCODE: -204. I know that this error say "table doesn't exists" but the syscat.tables show this the table.

I can execute the same statement in CLP or control center without problem.

What should I do?

The command is very simple:

delete from myschema.mytable where campo1=valor

Thanks!!

First of all, that is not the exact statement you submitted, nor is it the exact error returned, so it is hard to say what your problem is.

I do notice that your predicate contains a column that is character, but the value used in the comparison does not have single quotes.

Are you connecting to the same database in your java app and your control centre ?

Yes, is the same bd

Thank you.

OK, the statement is: delete from rrhh.emp where empyear=2011 and empmonth=9 and empday=13

error:

[2011-09-12 12:19:27.332] Hold : com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: RRHH.EMP

THANKS!!!!

Need to see the following:
db2 list tables for all

You can just show the one line that proves RRHH.EMP exists.

Thank
I ran the command and the table exists.