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?
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
Why select is not preferred in embedded sql programs?
What does a deadlock mean in DB2?
What is cascading rollback?
Define declaration generator (dclgen).
Can you use max on a char column?
What is the difference between nvl and coalesce?
What are foreign keys in db2?
What is the reason behind not using select * in embedded sql programs?
How do I connect my db2 database to ibm?
Which component is responsible for db2 startup and shutdown?
What is ibm db2 connect?
How does coalesce work?
What is buffer pool?
What is explain plan in db2?
What is a collection in db2?