for the 1st question: v can create table by the COMMAND CREATE TABLE tabl

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 / anish

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

Answer Posted / anish

for the 1st question:
v can create table by the COMMAND
CREATE TABLE table-name
column1 char(9)
.
.
...so on
And according to your installation u have to mention the
tablespace name & DB name.

for the 2nd question:
ALTER TABLE table-name
MODIFY USER_ID CHAR(12);

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is bufferpool in db2?

1045

What is consistency token in db2?

1134

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2929

List down the data types in the db2 database.

1112

What is concurrency?

1225

Explain package in db2 and its advantages?

1203

What is db2 bind?

1076

What is commit in db2?

1046

What is collection in db2 bind?

1006

What is the use of reorg in db2?

1078

What is meant by union and union all?

1006

What is a Foreign Key?

1095

How do I add a column in db2?

1043

How to find the maximum value in a column in the db2 database?

1071

How to get the ddl of a table in db2?

1127