in db2, already 10 columns arie der, and i want to insert 11th column. what para

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 / akila

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

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil conside..

Answer / azharuddinsyed

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB2 Interview Questions

can i code union in cobol-db2 pgm ?

4 Answers Patni,

What is blu acceleration in db2?

0 Answers

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers CTS,

What is an inner join, and an outer join ?

1 Answers CTA,

Explain package in db2 and its advantages?

0 Answers

what are the SQL codes u freequently got?

2 Answers Logica CMG,

What is the syntax for creating a table in the db2 database?

0 Answers

How do you filter out the rows retrieved from a Db2 table ?

1 Answers

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers Infosys,

how to unload different table data into different gdg files/ vsam files.

3 Answers

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?

2 Answers

What will the COMMIT accomplish?

5 Answers

For more DB2 Interview Questions Click Here