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?
- 4 Answers
- 9582 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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 check constraint in db2?
What is null indicator in db2?
Can we insert update delete in view?
What is a Foreign Key?
what is the sqlcode -501
What is deadlock in db2?
What is role in db2?
How many databases can be created inside an instance in db2 ?
How do I import a csv file into db2?
What is consistency token in db2?
What r the comman abends in db2, jcl and cobol???????
How to run db2 command in windows?
How do I add a column to a table in db2?
Explain in detail about buffer manager and its functionalities?
List out the data types available.
