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
- 7554 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 |
Is schema the same as database?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is CHECK PENDING ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How is the SUBSTR keyword used in sql?
What are the various locking levels available?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the command used by TSO users to invoke DB2?
How can deadlocks be resolved?
What are the prerogatives?
i have a db2 variable how do u declare tht into working storage section ?
What is the function of logging in the db2 database?
COBOL 
