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.
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 are the various data types available in db2?
Why cursor is used in db2?
What type of database is db2?
Which components manage deadlocks in db2?
What are the disadvantages of PAGE level lock?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is bind package and plan in db2?
What is performance tuning db2?
Why do we need reorg in db2?
is there any restrictions for unions ?
In terms of DB2 indexing, what is the root page?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,