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
10640 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 null in db2?

950

List out the data types available.

1084

What is scrollable cursor in db2?

998

Define db2.

1067

Give a brief description of db2 isolation levels?

1013

Which are the db2 tools to protect integrity of the database?

1073

What is a db2 table?

958

What is the function of logging in the db2 database?

1071

Explain how can you do the explain of a dynamic sql statement?

1066

How does coalesce work?

962

What is meant by union and union all?

948

What is the use of predicate?

985

What's The Error Code For Unique Index Voilation?

1155

How to fetch the last row from the table in SQL (db2)?

1590

What is a db2 collection?

981