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
- 10537 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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
When reorg is used?
Name the various locking levels available?
What is the difference between dbm cfg and db cfg file in db2 ?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to test SQL -911 error while developing COB-DB2 program
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is release/acquire in bind?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is bind in db2?
What is scrollable cursor in db2?
What is meant by union and union all?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to rename a table in DB2 ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
