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
- 7434 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 |
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What does the RUNSTATS Utility do?
What is CHECK PENDING ?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
How can record locking be achieved in those DB2 versions which do not support it?
Can SQL statements/queries be included in a copybook?
what is a plan and how do you refer the plan in the program?
What's the difference between DB2 active log and archive log? Thanks a lot...
what is rebinding ?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
COBOL 
