Hi Ram Prajapati , In db2 (esp in version 9.5) it is poosible to increas

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?

Question Posted / ratheesh nellikal

6 Answers
10733 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / ratheesh nellikal

Hi Ram Prajapati ,

In db2 (esp in version 9.5) it is poosible to increase the
size of a column without loosing the data.
But u can not decrease the size.

Cheers ,
Ratheesh Nellikkal

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by commit and rollback?

1012

What os does db2 run on?

940

Why do chiropractors use drop table?

1060

What action db2 takes when a program aborts in the middle of a transaction?

1117

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1136

What is check constraint in db2?

1029

Why do we bind in db2?

1169

How do I import data from excel to db2?

1032

What is db2? Explain.

1000

What is table space in db2?

978

What does db2 plan contain?

987

What is deadlock in db2?

1037

What is db2 bind?

1035

What is commit in db2?

1010

How does a cursor work?

942