Answer Posted / 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 |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is database reorganization?
Mention data types used in db2 ?
What is multi row fetch in db2?
What is runstats and reorg in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain the contention situations caused by locks?
What os does db2 run on?
What is the clustering index in the db2 database?
What is the information associated with sysibm.syslinks table?
Are view updateable?
Explain dclgen.
What is the cobol picture clause of the db2 data types date, time, timestamp?
What language is db2 written in?