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

What are bind parameters in db2?

829


Why cursor is used in db2?

795


What does reorg do in db2?

800


What is ibm db2 database?

755


What is the information associated with sysibm.syslinks table?

901


Which command is used to connect to a database in DB2 ? Give the Syntax.

863


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2547


What is the difference between bind and rebind in db2?

1213


What is the picture clause of null indicator variable?

918


Define data page.

848


How do you select a row using indexes in db2?

874


Comment whether the cursor is closed during commit or not.

893


How to compare data between two tables in db2?

870


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1867


Name the lockable units in DB2?

923