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
- 10897 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 the role of schema in the db2 database?
What are concurrency issues?
How to test SQL -911 error while developing COB-DB2 program
What is the maximum size of a char data type in db2?
How can the duplicate values be eliminated from db2 select?
what are bind concepts in db2 cobol?
Explain about dbrm.
Where do you specify them?
is it compulsory commitment control in journal?
Explain in brief how does db2 determine what lock-size to use?
What is coalesce in db2?
What parameters are used to control the free space in DB2?
What is ibm db2 database?
Give the name of some fields form sqlca.
What is isolation level in db2?
