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

what is the input to PLAN?
what is the input to DBRM?

Question Posted / gopalandharinder

Answers were Sorted based on User's Feedback



what is the input to PLAN? what is the input to DBRM?..

Answer / harish

dbrm or package is input to plan....talking abt
dbrm.......the cobol+db2 prgrm is input to precompiler which
separtes cobol souce code and dbrm

Is This Answer Correct ?    8 Yes 2 No

what is the input to PLAN? what is the input to DBRM?..

Answer / mani

DBRMs and Packages are the input to the plan as said above.
The input to DBRM is the sql statements in the cobol db2
program
i.e all the sql statements in the cobol db2 program will be
replaced by the host language statements in this case it is
cobol and the sql statements are bound into DBRMs.

Is This Answer Correct ?    2 Yes 2 No

what is the input to PLAN? what is the input to DBRM?..

Answer / guest

The input to a plan is a DBRM or package. The DBRM is a
copy of the SQL statements of the program that is being
prepared.

Is This Answer Correct ?    1 Yes 1 No

what is the input to PLAN? what is the input to DBRM?..

Answer / anil reddy

DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.

PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

Explain an outer join?

1 Answers  

how to fetch multiple records without using cursor

14 Answers   HCL,

How to handle null values in db2

4 Answers  

Define sqlca.

0 Answers  

What is database manager in db2?

0 Answers  

what is consistency token

3 Answers  

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

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

0 Answers  

What is host variable in db2 cobol?

0 Answers  

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

Is schema the same as database?

0 Answers  

For more DB2 Interview Questions Click Here
Categories