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



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

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


What is scrollable cursor in db2?

0 Answers  


What is lock escalation in db2?

0 Answers  


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


What is runstats db2?

0 Answers  






if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


what is the difference between where clause and having clause

2 Answers   IBM,


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

5 Answers   DELL, HCL,


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

0 Answers   Infosys,


What is the SQL Communications Area and what are some of its key fields?

1 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 is the advantage in De-normalizing tables in DB2?

0 Answers  


Categories