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

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

 

 

  • krmilligan
    krmilligan
    450 Posts

    Re: No able to deleting the table

    ‏2013-07-29T18:19:10Z  

    Please on the DB2 for Linux, Unix, & Windows forum:

     

    https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000842

  • DF5V_krishna_Bissa
    DF5V_krishna_Bissa
    3 Posts

    Re: No able to deleting the table

    ‏2013-07-31T08:25:40Z  

    thanks for 

    Diverting me to the right forum.