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
On which levels locks can be applied?
What does db2 blu stand for?
Comment whether the cursor is closed during commit or not.
What are the uses of db2 optimizer?
What is a collection in db2?
What is cobol db2?
What is a db2 tablespace?
Explain about mirror activator disk mirroring?
What is buffer pool in the db2 database?
What is collection in db2 bind?
What is drop table?
What is the physical storage length of the data types date, time, and timestamp?
What is db2 purescale?
What is coalesce in db2?
What is the clustering index in the db2 database?