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
- 8939 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 a collection in db2?
How can you quickly find out the # of rows updated after an update statement?
What are the uses of db2 optimizer?
What is view db2?
How does db2 sample database connect?
Why select is not preferred in embedded sql programs?
When the like statement is used?
What is the difference between plan and package in db2?
Explain how can you do the explain of a dynamic sql statement?
How can you count the number of rows from a table tab?
What is ibm db2 used for?
Can you tell me how can you find out the # of rows updated after an update statement?
Which components manage deadlocks in db2?
What is the use of with ur in db2?
What is check constraint in db2?
