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

1 Answers
3098 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / azharuddinsyed

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the meaning concurrency in the db2 database?

1055

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?

8132

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3519

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

1062

What is dbrm? When it will be created?

956

What is netezza database?

958

What does runstats do in db2?

1022

On which levels locks can be applied?

1060

What is a db2 tablespace?

998

How to find primary key of a table in db2?

1001

What does db2 blu stand for?

1100

What is the default page size of buffer pools?

1069

How do I change the column size in db2?

1082

How do I start db2 in windows?

1020

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

1070