We had a table create in both upper case and lower case (temp_rob and TEMP_ROB). We did a drop able on TEMP_ROB. temp_rob still shows in the systables and syscat.columns.

This causes issues in another applicaiton that reads these tables and looks for permissions on those tables. It failts because any attempt at a drop or select on temp_rob results in

"Error 09/01/2009 13:43:17 0:00:00.000 DB2 Database Error: ERROR [42704] [IBM][DB2/NT64] SQL0204N "LYNX.TEMP_ROB" is an undefined name. SQLSTATE=42704"

Any thoughts on how we can remove temp_rob from system tables?

Thanks!

I see an attempt to access "TEMP_ROB", not "temp_rob". Case sensitive object names should be enclosed in double quotation marks.

Nick.

I noticed that as well. Your suggestion worked perfectly. Using drop table "temp_rob" allowed me to drop the table.

Life is wonderful.

Thanks very much.