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...


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



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

Answer / shyam

In the Plans or packages which has the Static SQL's,
Authorization check is done based on the VALIDATE parameter
in BIND control card ..If VALIDATE(BIND), Authorization
check is done during the BIND time. If VALIDATE(RUN),
Authorization check is done during the run time.

For the plans or packages having Dynamic SQL's ,
Authorization check is done during the run time.

Shyam

Is This Answer Correct ?    16 Yes 1 No

Post New Answer

More DB2 Interview Questions

What are the benefits of using the db2 database?

0 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


What is check constraint. Explain with example.

0 Answers  


How does DB2 store NULL physically?

2 Answers  


how to unload different table data into different gdg files/ vsam files.

3 Answers  


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


What is data manager?

0 Answers  


Explain in brief how does db2 determine what lock-size to use?

0 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,


What is coalesce in db2?

0 Answers  


Categories