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?
- 1 Answers
- 13848 Views
- I also Faced
- E-Mail Answers
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 |
What is a Database Request Module(DBRM)?
How to run db2 command in windows?
What techniques will be used to avoid deadlock??
what is sql abend code -801,-802?
Where are plans stored?
What is a db2 schema?
What is DCLGEN?
Could anyone clearly explain the diference between sub query and correlated sub query?
WHAT IS MEANT BY COMMIT COMMAND?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
what are the bind parameters?
What is a page?
COBOL 
