ALTER TABLENAME ADD COLUMN <COLUMN NAME> <DATATYPE>(<

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

Question Posted / azharuddinsyed

Answer Posted / azharuddinsyed

ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I start db2 in windows?

1104

What is the default page size of buffer pools?

1125

What is reorg?

1165

What does db2 plan contain?

1031

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

2952

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

1116

define clustering index.

1036

How to access db2 tables in mainframe?

1060

What r the comman abends in db2, jcl and cobol???????

2262

What is blu acceleration in db2?

1078

List some fields from sqlca?

1062

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1053

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

1112

How do I delete a table in database?

1030

How do you select a row using indexes in db2?

1141