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
11139 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 precompiler in db2?

1080

What is db2?

1236

What is database manager in db2?

1067

What is catalog database in db2?

1218

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8382

How would the varchar column remarks defined?

1135

How can you find out the # of rows updated after an update statement?

1154

Describe major components of db2?

1148

What is ibm db2 database?

1069

What is the difference between bind and rebind in db2?

1513

What is db2 bind process?

1292

Name the various locking levels available?

1136

Which component is responsible for processing sql statements and selecting access paths?

1178

What is the difference between using bind () and rebind () methods of naming class?

1463

What is an instance database?

1098