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
3199 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

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers

Why select is not preferred in embedded sql programs?

0 Answers

What is pagespace?

1 Answers

can we update the table by using cursors can anyone post the query?

5 Answers DELL, HCL,

my project is insurance management system,how to explain my work environment in interview?

2 Answers CGI, Value Labs,

Name the various locking levels available?

0 Answers

Write a query to retrive partial string.

2 Answers

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers Infosys,

what is datacom db?

2 Answers CSC,

What is the significance of DB2 free space and what parameters control it?

1 Answers

What is cursor stability?

1 Answers

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers

For more DB2 Interview Questions Click Here