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 / shailendra
i think, the size of variable is not possible to change,
please correct me if i am wrong.
so for the solutionwe can creat new table with change of
the size of user_id char(12)
and if you want the same name of table
step1 >creat a table for interface perpose with user_id char
(12)
2> insert all the data in the interface table
3> delete the main table.
4> create table with same name of main table with
user_id char(12)
5> insert data from interface table to main table.
now i think it will work.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to rename a table in DB2 ?
What is iseries database?
What is ibm db2 database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is lock escalation in db2?
What is db2 instance?
what is the responsibility of the construction superintendent
Where can you declare a cursor in a cobol-db2 program?
Mention the downsides of page level lock.
What is database alias db2?
Is it possible using max on a char column?
Name the various locking levels available?
What is the physical storage length of the data types date, time, and timestamp?
Is it possible to create an Instance in DB2 using DB2 Control Center ?