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



Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 t..

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

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 t..

Answer / 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

More DB2 Interview Questions

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  


When the like statement is used?

0 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


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

0 Answers  


What is the difference between nvl and coalesce?

0 Answers  


What is sqlca?

0 Answers  


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


What is sqlcode -922 ?

2 Answers  


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  


What is the self-referencing constraint?

2 Answers  


Name the lockable units in DB2?

0 Answers  


Categories