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 |
How many sub queries can you combine together ?
What is data manager?
What are some characteristics of columns that benefit from indexes?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is load utility in db2?
What is the role of the data page in the db2 database?
How do you eliminate duplicate values in db2?
How to define the a field which accepts value till 99999.99 in db2
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is the physical storage length of timestamp data type?