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
- 8891 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 are iseries servers?
Why do we use cursor?
What are types of indexes?
What are catalog tables in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Can you tell me how can you find out the # of rows updated after an update statement?
What is meant by explain?
How do we specify index to include or not during bind process.
What is db2 stogroup?
Mention the different locking levels that are available in db2.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What language is db2 written in?
Is ibm db2 free?
Mention the definition of cobol in varchar field.
is it compulsory commitment control in journal?
