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
- 6826 Views
- RBS, I also Faced
- E-Mail Answers
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 is cloudant database?
What is null indicator in cobol db2?
Which is faster delete or truncate?
What is commit in db2?
What are bind parameters in db2?
How to resolve deadlock issue
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are the two types of logging in the db2 database? Explain them.
What is a db2 cursor?
Which component is used to execute the sql statements?
What is coalesce in db2?
What is scrollable cursor in db2?
How would you find out the total number of rows in a db2 table?
Why cursor is used in db2?
How can you classify the locks in db2?
