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


Please Help Members By Posting Answers For Below Questions

What is meant by dclgen?

618


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

712


Can we delete records from view?

558


What is buffer pool in the db2 database?

610


What is the maximum size of a char data type in db2?

582






Is the primary key a clustered index?

606


How to compare data between two tables in db2?

654


How many types of page locks can be held in db2?

589


What is phantom read in db2?

636


What does db2 plan contain?

571


What are the various isolation levels possible?

643


Mention the various locks that are available in db2.

614


What are types of indexes?

587


Is ibm db2 open source?

581


What is the use of with ur in db2?

615