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
- 10627 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 lock escalation in db2?
How to check sequence on a table in db2?
what is the role of the cursor in db2?
What is view db2?
How do you pull up a query which was previously saved in qmf?
What does a deadlock mean in DB2?
What are bind parameters in db2?
What is meant by union and union all?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the picture clause of null indicator variable?
When the like statement is used?
Discuss about db2 bind?
How is deadlock resolved?
How do I delete a table in database?
What are types of indexes?
