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 iseries servers?
How to resolve deadlock issue
When the like statement is used?
What is meant by union and union all?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is page size in db2?
What is the maximum size of a char data type in db2?
How do I import data from excel to db2?
When do you specify the isolation level?
What is role in db2?
What is cursor with hold option in db2?
Where do you specify them?
How would the varchar column remarks defined?
What is iseries database?