Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

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

What are union and union all?

0 Answers  

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

what is utility for parm lib

0 Answers   IBM,

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

How to resolve deadlock issue

5 Answers   IBM,

What parameters are used to control the free space in DB2?

0 Answers  

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

What are bind parameters in db2?

0 Answers  

How would one remove old reorg information from the DB2 catalog?

2 Answers  

For more DB2 Interview Questions Click Here
Categories