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
- 10422 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
How to retrieve rows from a db2 table in embedded sql?
Is the primary key a clustered index?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How to find the number of rows in db2 tables?
Which is faster delete or truncate?
What is rct?
Define db2.
How do you select a row using indexes in db2?
Mention the different locking levels that are available in db2.
What is package in db2 mainframe?
How do I delete a column in db2?
Can there be more than one cursor open for any program?
what is a corelated subquerry?
