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. 

Answers were Sorted based on User's Feedback



Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 t..

Answer / gaurav alugh

We can do our code (in this code define everything for both the tables) and on the basis of DATE function from COBOL we can see what's the date. on the basis of that we can call our query referring to required tables.  

Is This Answer Correct ?    4 Yes 3 No

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 t..

Answer / karthis4u

I wonder where do we mention qualifier name in program? We mention it in bind card.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

How many sub queries can you combine together ?

4 Answers   IBM,


What is data manager?

0 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,


What is load utility in db2?

0 Answers  


What is the role of the data page in the db2 database?

0 Answers  


How do you eliminate duplicate values in db2?

0 Answers  


How to define the a field which accepts value till 99999.99 in db2

3 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,


if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,


What is the physical storage length of timestamp data type?

0 Answers  


Categories