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 / rahul
If table is empty then we alter this column to any length,
but if some data got inserted into the table then we can
also decrease the column length upto largest data size
available in that perticulat column.
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is the use of db2 optimizer?
How do you stop a db2 database in linux?
What is query_cache_limit?
What is the use of dclgen in db2?
Explain about rct in db2?
How is the value function used?
Highlight all the advantages that are attached to a package.
What is the physical storage length of date data type?
What is the use of commit in db2?
What is the difference between db2 and oracle?
What is the default page size of buffer pools?
What is explain in db2?
What is page size in db2?
Define declaration generator (dclgen).
What is bind package and plan in db2?