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?
Answer Posted / naidu sekhar yandrapu
once enter into column length ,we can increase the data length if a table is empty but if the table is non empty we can only
increase the(data length)
in this situation add one more column should be size is 8.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
How do you pull up a query which was previously saved in qmf?
What is netezza database?
What is the difference between bind and rebind in db2?
What is database alias db2?
What is reorg and runstats in db2?
What is role in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is image copy in db2?
What is the difference between cursor stability and repeatable read isolation levels?
Name the lockable units in DB2?
Can we delete records from view?
What are the full forms of spufi and dclgen and why are they used?
Why cursor is used in db2?
what is the responsibility of the construction superintendent
What is nvl in db2?