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
- 11347 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
Is db2 a mainframe?
B37 abend during spufi?
Explain about rct in db2?
What is reorg and runstats in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How can the duplicate values be eliminated from db2 select?
What is reorg?
What are the uses of db2 optimizer?
What is the clustering index in the db2 database?
How to fetch the last row from the table in SQL (db2)?
Can one database have multiple instances?
What are packages in db2?
What is consistency token in db2?
What do you mean by rollback?
How can you do the explain of a dynamic sql statement?
