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
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 are extents?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
how to resolve -805. give clear explination for that
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What is isolation level in db2?
What are the abend codes occour in ur latest PROJECT in DB2
B37 abend during spufi?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
How do I delete a column in db2?
What is dbrm in db2 database?
how can u retrieve the data from null values using applicaion program.
List down the data types in the db2 database.