Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7466 Views
- RBS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
What is blu acceleration in db2?
What is the use of predicate?
What is ibm db2 connect?
What is isolation level in db2?
What are bind parameters in db2?
What is image copy in db2?
Why db2 is called db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is EXPLAIN?
What is cursor?
What is a system catalog table in db2?
COBOL 
