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
10701 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

Mention some fields that are a part of sqlca.

989

What is table space in db2?

971

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1034

What kind of database is db2?

995

How to compare data between two tables in db2?

1047

Mention the location where the output received from explain statement is stored.

1080

What do you mean by between and in? Is between inclusive of specified range values?

1053

How do I import a csv file into db2?

948

How many types of page locks can be held in db2?

1000

Before you give the explain statement, what are the prerogatives?

987

Comment whether the cursor is closed during commit or not.

1052

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2135

What are iseries servers?

1026

What language is db2 written in?

991

How to create backup table in db2?

1056