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?
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 ibm db2 connect?
How do I delete a table in database?
What are the bind parameters ibm db2?
What is declare cursor?
What is the default page size of buffer pools?
What is the role of data manager in the db2 database?
What is the use of db2 optimizer?
How and when does the db2 enforces the unique key?
What is ibm db2 used for?
What is blu acceleration in db2?
What is db2?
what is db2 restart?
What is check constraint. Explain with example.
Outputs of explain are with matchcols = 0. What does this signify?
What does db2 mean?