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
- 10719 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
Name the various locking levels available?
What is the information associated with sysibm.syslinks table?
What is the meaning concurrency in the db2 database?
How is a typical db2 batch pgm executed?
What is an instance in db2?
What is database alias db2?
Which component is responsible for db2 startup and shutdown?
How can record locking be achieved in those DB2 versions which do not support it?
What are iseries servers?
How do I start db2 in windows?
What is a storage group (stogroup)?
Mention the definition of cobol in varchar field.
What is null in db2?
How does db2 sample database connect?
How can you do the explain of a dynamic sql statement?
