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
- 7340 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 |
Who uses db2?
What is the difference between IN subselects and EXISTS subselect?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
how to u check the query is executing or not ?where will u check for sqlcode ?
Which is faster delete or truncate?
What is buffrpool? Where we use it ?
What is dclgen in db2?
Once you create a view, where would information about the view be stored?
Give a brief description of db2 isolation levels?
What is -904 sql code? How to resolve it?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
what's the best lock size that you could use when you create a tablespace?
COBOL 
