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 prerogatives?
What is the physical storage length of the data types date, time, and timestamp?
What is blu acceleration in db2?
What is cloudant database?
Can we update view in db2?
What is db2 bind process?
Name the lockable units in DB2?
What is the physical storage length of time data type?
What is host variable?
When the like statement is used?
What do you mean by commit and rollback?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which command is used to remove all rows from a table?
What are the various isolation levels possible?
What is dbrm? What it contains? When it will be created?