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 are the benefits of using the db2 database?
What is the meaning concurrency in the db2 database?
What is multi row fetch in db2?
How is the value function used?
What is a bind card?
List down the data types in the db2 database.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is meant by union and union all?
What r the comman abends in db2, jcl and cobol???????
What is node in db2?
What is ibm db2 connect?
How can deadlocks be resolved?
What is plan in cobol db2?
Mention the different locking levels that are available in db2.
What is rebind in db2?