Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11127 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / hi
Yes, it's possible to increase/decrease the size. While
decreasing, need to make sure that none of the records
present in the column conflict the modification. e.g. to
reduce the size of the column which is CHAR(6) to CHAR(4),
with one of the record value as 'ABCDE' will give an error.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is cursor in dbms?
Outputs of explain are with matchcols = 0. What does this signify?
What does db2 mean?
What is an instance database?
what is a corelated subquerry?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is load replace in db2?
What is the picture clause of null indicator variable?
What is a db2 table?
What are the rules for db2 programming?
What is buffer pool and list some of them?
What is runstats db2?
what is db2 restart?
what is the role of the cursor in db2?
