Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11167 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 the difference between cursor and select statement?
What is buffer pool?
What is check constraint. Explain with example.
What is the difference between plan and package in db2?
What is sqlca’s maximum length?
Explain various types of locks in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is load replace in db2?
Why do we bind in db2?
Before you give the explain statement, what are the prerogatives?
Explain about rct in db2?
Comment whether the cursor is closed during commit or not.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What type of database is db2?
Explain package in db2 and its advantages?
