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.
Answer Posted / 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 |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is difference between isnull and coalesce?
What is db2 instance?
Explain about open switch business continuity software?
How do we specify index to include or not during bind process.
What do you mean by between and in? Is between inclusive of specified range values?
What is access path in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is netezza database?
What is null value in db2?
What is cloudant database?
What happens in bind step in a db2 program?
Name the lockable units in DB2?
Define db2.
What is copy pending and check pending in db2?