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
What are the contents of a dclmgen?
What is release/acquire in bind?
What is table space in db2?
What is cursor with hold option in db2?
Mention the different locking levels that are available in db2.
What is clone table?
i want to maintain uniqueness on pdf without make lf??????????
What is host variable in db2 cobol?
What is db2 bind process?
What does sqlcabc has?
List out the three types of page locks that can be held.
What are concurrency issues?
How to connect to db2 database from windows command line?
Explain about dbrm.
Explain how can you do the explain of a dynamic sql statement?