How do I add a column to a table in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

Explain the contents that are a part of dclgen.

0 Answers  


What db2 400?

0 Answers  


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


how to fetch multiple records without using cursor

14 Answers   HCL,


How to compare data between two tables in db2?

0 Answers  






How to resolve -805 error in DB2?

1 Answers   Cap Gemini,


what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  


What is read-only cursor?

1 Answers  


What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,


Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,


If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  


Categories