Interested to Buy Any Domain ? << Click Here >> for more details...
While creating a table, by mistake you have given size of one
field as 10. But as per requirement size should be 8. What is
your next step?
- 4 Answers
- 11166 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / hameed shaik
In Db29 we can alter the column size but cannot delete the column..
I did it so many times.. ALTER TABLE Tablename ALTER COLUMN columnname SET DATA TYPE VARCHAR(51)
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does a deadlock mean in DB2?
What are the benefits of using the db2 database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are the prerogatives?
What is the use of reorg in db2?
is it compulsory commitment control in journal?
Can one database have multiple instances?
List down the types of triggers in the db2 database?
Why db2 is called db2?
How to create db2 table in mainframe?
How to find schema of a table in db2?
Explain in brief how does db2 determine what lock-size to use?
What is clone table?
What is dclgen in db2?
