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
What is a db2 package?
Which is faster delete or truncate?
What is the use of db2?
What is drop table?
What is rebind in db2?
can we view the access paths created by dbrm ? how ? thx
i want to maintain uniqueness on pdf without make lf??????????
How do I change the column size in db2?
What are types of indexes?
What is the usage of open cursor command?
How do I import data from excel to db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do I add a column to an existing table in db2?
Define check constraint.
What are union and union all?