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
B37 abend during spufi?
What are iseries servers?
What is a storage group (stogroup)?
How will you return the number of records in table?
Mention data types used in db2 ?
can all users have the privilage to use the sql statement select * (dml)?
What is node in db2?
What is clone table?
Which command is used to remove all rows from a table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is catalog database in db2?
How can we retrieve the total number of records in RPG & CLLE?
Is schema the same as database?
Can there be more than one cursor open for any program?
What is precompiler in db2?