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
- 7560 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 difference between rollback and commit?
What is buffer pool in the db2 database?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is a bind card?
what is the difference between normal select query and currosor
What is the use of commit in db2?
Where besides the DB2 catalog is database object information stored by DB2?
What is the syntax of SELECT statement when embedded in a COBOL program?
What is a synonym ?
Can there be more than one cursor open for any program?
what is a collection?
COBOL 
