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 are foreign keys in db2?
What is db2 purescale?
What is universal database?
What are the uses of db2 optimizer?
What is dbrm library?
What is iseries database?
How do I delete a column in db2?
Is db2 relational database?
How do you pull up a query which was previously saved in qmf?
When the like statement is used?
What is db2 look?
How will you return the number of records in table?
Explain about dbrm.
Give the name of some fields form sqlca.
What is the function of logging in the db2 database?