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 is universal database?

0 Answers  

How can you get the number of rows impacted by the last executed query?

1 Answers  

What is bind package and plan in db2?

0 Answers  

How to compare data between two tables in db2?

0 Answers  

What are foreign keys in db2?

0 Answers  

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

What is database alias db2?

0 Answers  

What is db2?

0 Answers  

What is check constraint. Explain with example.

0 Answers  

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories