ALter is to change db2 table definition. for eg: Alter tablename add col

What is ALTER ?

Question Posted / jitendra

Answer Posted / jitendra

ALter is to change db2 table definition. for eg:
Alter tablename
add column number(11,2)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1313

What is the latest version of ibm db2?

1335

How do you select a row using indexes in db2?

1175

What is check constraint. Explain with example.

1159

What is the difference between dbm cfg and db cfg file in db2 ?

1591

Explain the contents that are a part of dclgen.

1137

Explain various types of locks in db2?

1204

can all users have the privilage to use the sql statement select * (dml)?

1221

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3203

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1157

Which component is responsible for db2 startup and shutdown?

1083

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

1087

What is the maximum size of a char data type in db2?

1050

How do we specify index to include or not during bind process.

2173

What is sqlca’s maximum length?

1248