Interested to Buy Any Domain ? << Click Here >> for more details...
How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it?
- 6 Answers
- 10926 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikal
Hi Ram Prajapati ,
In db2 (esp in version 9.5) it is poosible to increase the
size of a column without loosing the data.
But u can not decrease the size.
Cheers ,
Ratheesh Nellikkal
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is explain in db2?
What is lock escalation in db2?
What do you mean by rollback?
What are the 2 sqlcodes that are returned?
What is the use of reorg in db2?
What is the maximum number of columns in a db2 table?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Are views updateable?
B37 abend during spufi?
What do you mean by commit and rollback?
How do I add a column to an existing table in db2?
How to check last update on table in db2?
How can you count the number of rows from a table tab?
What is sqlca’s maximum length?
Is it possible using max on a char column?
