can we drop column from a table
Answers were Sorted based on User's Feedback
Answer / srini
We can not drop a column. If we want we can append colume
with ALTER command.
Is This Answer Correct ? | 30 Yes | 9 No |
Answer / prem
It depends on DB2 version.
In DB2 V9 we can drop a column.
In DB2 V8 we cant.
Is This Answer Correct ? | 12 Yes | 3 No |
Answer / kumar
It is not possible directly. Indirectly we could do it.
Create a view by eliminating the column (th one to be
deleted). Drop the table or create a new table. Copy from
the view to the newly created table. Pl correct if I'm
wrong.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / rbs
yes we can drop, but column should not have any data.
eg: ALTER TABLE <TB NAME> DROP COLUMN Col-name.
Is This Answer Correct ? | 3 Yes | 10 No |
Answer / zoheb ali ahmed
Drops only take place at, minimum, table level.
Is This Answer Correct ? | 0 Yes | 13 No |
Answer / nitesh
yes we can drop any column
ALTER TABLE <TABLENAME> DROP COLUMN <COLUMNNAME>
e.g ALTER TABLE EMP DROP COLUMN NAME
Is This Answer Correct ? | 20 Yes | 36 No |
How do I delete a table in db2?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is collection in db2 bind?
In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
what is db2 restart?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
How to define the data items to receive the fetch items for the SQL?
How many buffer pools are there in DB2?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What is a db2 schema?
Request to database but database is not available so what is was abend is raised?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;