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
- 6808 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 |
What is query_cache_limit?
How would you find out the total number of rows in a db2 table?
is there any restrictions for unions ?
Mention the various locks that are available in db2.
What is the picture clause of null indicator variable?
What is buffer pool in the db2 database?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
Is ibm db2 open source?
What information can you find in SYSIBM.SYSLINKS table?
What is a precompiler?
What techniques will be used to avoid deadlock??
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
COBOL 
