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


Please Help Members By Posting Answers For Below Questions

How do I delete a column in db2?

870


What is the maximum size of varchar data type in db2?

865


What is a dbrm in db2?

758


What are the 2 sqlcodes that are returned?

875


What is runstats utility in db2?

767


What is cursor stability in db2?

1057


Why do chiropractors use drop table?

889


What is dbrm? What it contains? When it will be created?

803


define clustering index.

808


What is dclgen (declaration generator)?

824


What is database reorganization?

841


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

803


Mention the downsides of page level lock.

925


How to create db2 table in mainframe?

865


what is diffrence b/w file-aid tool and file-aid utility???

4534