Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by storage group (stogroup)?
What is bind plan?
What is the purpose of using commit?
What is db2 and what is the use of db2 optimizer?
What's The Error Code For Unique Index Voilation?
What does runstats do in db2?
What is cobol db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the difference between nvl and coalesce?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How can record locking be achieved in those DB2 versions which do not support it?
What is a db2 schema?
What are the different types of base tables?
Where do you specify them?
What is buffer pool?
