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?
Answer Posted / naidu sekhar yandrapu
once enter into column length ,we can increase the data length if a table is empty but if the table is non empty we can only
increase the(data length)
in this situation add one more column should be size is 8.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What kind of database is db2?
How do I add a column to an existing table in db2?
Name the various locking levels available?
What is rebind in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is dclgen in db2?
Can one database have multiple instances?
What is difference between rollback and commit?
What is explain plan in db2?
Explain about dbrm.
What is dbrm library?
How do you pull up a query which was previously saved in qmf?
Which isolation level provides highest data integrity?
Is db2 free?
How is the value function used?