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

What Utility is used to migrate DB2 from one release to the next?

1 Answers  


What do you do to keep the cursor from closing after a commit?

1 Answers  


How to design maps

1 Answers   Virtusa,


EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


What is db2 optimizer?

0 Answers  


What does an outer join do?

1 Answers   CTS,


What is db2 connect?

0 Answers  


What is difference between isnull and coalesce?

0 Answers  


What do you need to do before you do EXPLAIN ?

1 Answers  


Can we insert update delete in view?

0 Answers  


Explain db2.

0 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


Categories