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
- 11346 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / mr.perfect
IF field is having empty in table , then we can reduce or
increase the size of the field, using the alter statement .
i.e . alter table <tablename>
modify <new columnname ><data type><new size>
if the data in the table is non-empyt, then we cannot alter
the table. better to delete the column and add the same
column to new size.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the maximum size of a char data type in db2?
What is sqlca?
What is netezza database?
What is the role of the data page in the db2 database?
Why do we need reorg in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is package in cobol db2?
On which levels locks can be applied?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is cloudant database?
What is the difference between dbm cfg and db cfg file in db2 ?
Explain how can you do the explain of a dynamic sql statement?
What is buffer pool?
