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 are the full forms of spufi and dclgen and why are they used?
What's The Percentage Free Space ?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are the 2 sqlcodes that are returned?
What is difference between rollback and commit?
What is catalog database in db2?
What is the maximum number of columns in a db2 table?
Define sqlca.
What is the physical storage length of the data types date, time, and timestamp?
What is access path in db2?
What is the syntax for creating a table in the db2 database?
What is a db2 package?
What is table space in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is phantom read in db2?