Hi,

I was just testing something out and found a weird problem --

I tried to create a sample table in my main tablespace --

CREATE TABLE TempTPeakData (
"SITEID" INTEGER NOT NULL ,
"PVAL" DOUBLE NOT NULL ,
"PDATETIME" TIMESTAMP NOT NULL )
DATA CAPTURE CHANGES
IN "P_TBLSP" ;

I can create the table just fine but have issues when trying to describe/drop this table... I keep getting this message :

Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------

0 record(s) selected.

SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table. SQLSTATE=02000


If I give.. db2 "list tables", I see the table name in the list. Am I getting this error because the table is a mix of lowercase/uppercase letters? If so, how can I drop it? Also, if I use the All Caps version as the table name, I don't have any issues at all...thanks!

if the tablename consists of upper- and lowercase character, put it into double quotes.
e.g.
DROP TABLE "TempTPeakData" ;

thanks much...i will try it out!

To avoid guesswork, try this:

great thanks! btw..umayer.. the command you gave worked..

You should probably drop and recreate the table with a case insensitive name. Otherwise you are likely to lynched by a mob of angry developers and fellow DBA's.