We can do our code (in this code define everything for both the tables) and

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.

Question Posted / gaurav alugh

2 Answers
7337 Views
RBS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by explain?

1062

What is the use of predicate?

983

What is load replace in db2?

936

What is iseries database?

990

When the like statement is used?

1156

What is db2 plan table?

992

List down the data types in the db2 database.

1041

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

What are the uses of db2 optimizer?

1223

Explain the benefits you can get from mainframe connect?

910

What is the difference between using bind () and rebind () methods of naming class?

1328

What is db2 command?

963

What is db2 stogroup?

1095

What is cloudant database?

1032

What is alias in db2?

981