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
- 13745 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 ibm db2 connect?
How many clustering indexes can be defined for a table?
Can you tell me how can you find out the # of rows updated after an update statement?
How does coalesce work?
What is the maximum size of varchar data type in db2?
what is the use of commit ? and what is the syntax?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is db2 purescale?
How can you classify the locks in db2?
what is cursor stability?
What is the STOSPACE Utility used for?
How do you do the EXPLAIN of a dynamic SQL statement?
COBOL 
