Topic
2 replies Latest Post - ‏2013-07-31T08:25:40Z by DF5V_krishna_Bissa
DF5V_krishna_Bissa
DF5V_krishna_Bissa
3 Posts
ACCEPTED ANSWER

Pinned topic No able to deleting the table

‏2013-07-27T11:39:08Z |

Hi all,

By mistake i have created a table on "DB2 v9.5.0.8" on AIX witht the naming covention as  "testCD.CATENTATTR"

Requirement: i want to drop the table testCD.CATENTATTR now.- table is a empty 

 

Details:

db2 "select tabname from syscat.tables where tabschema='testCD'"

TABNAME
--------------------------------------------------------------------------------------------------------------------------------
CATENTATTR

table drop commands that i tried.

1. db2 "drop table testCD.CATENTATTR"
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0204N  "TESTCD.CATENTATTR" is an undefined name.  SQLSTATE=42704

 

2.db2 drop table testCD.CATENTATTR
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0204N  "TESTCD.CATENTATTR" is an undefined name.  SQLSTATE=42704
 

3.db2 "drop table "testCD"."CATENTATTR""
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0204N  "TESTCD.CATENTATTR" is an undefined name.  SQLSTATE=42704

I was not able to delete the table, as the DB2 is trying to delete TESTCD.CATENTATTR which is different from the name that i have mentioned in the command line "testCD"."CATENTATTR"".

I know, we should not have the schemaname with the combination of upper and lowercase letters.but i have created the table by mistake and now i want to delete it.Please let me know on the right approch to do that.

Other actions:tried renaming the table name-noluck

                         :tried dropping the schema testCD-noluck