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
- 10482 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
What is the difference between bind and rebind in db2?
Explain the function of data manager.
What is a trigger in the db2 database?
What are union and union all?
Is ibm db2 free?
How do I create a view in db2?
Mention the definition of cobol in varchar field.
How do we specify index to include or not during bind process.
How connect db2 database to datastage?
can we view the access paths created by dbrm ? how ? thx
What is meant by union and union all?
What os does db2 run on?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to find the maximum value in a column in the db2 database?
What is the default page size of buffer pools?
