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 do I delete a column in db2?
What is the maximum size of varchar data type in db2?
What is a dbrm in db2?
What are the 2 sqlcodes that are returned?
What is runstats utility in db2?
What is cursor stability in db2?
Why do chiropractors use drop table?
What is dbrm? What it contains? When it will be created?
define clustering index.
What is dclgen (declaration generator)?
What is database reorganization?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Mention the downsides of page level lock.
How to create db2 table in mainframe?
what is diffrence b/w file-aid tool and file-aid utility???