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.
Answer Posted / karthis4u
I wonder where do we mention qualifier name in program? We mention it in bind card.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain about mirror activator disk mirroring?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a collection in db2?
What is ibm db2 used for?
What is the latest version of ibm db2?
What is cobol db2?
What is the difference between dbm cfg and db cfg file in db2 ?
How would the varchar column remarks defined?
What is explain plan in db2?
Explain the function of data manager.
What is difference between alias and synonym in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is buffer pool and list some of them?
What is runstats utility in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?