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
- 13843 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How can you quickly find out the # of rows updated after an update statement?
How to check last update on table in db2?
Mention the various locks that are available in db2.
How would you find out the total number of rows in a db2 table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is cascading rollback?
What is a db2 package?
What does reorg do in db2?
Define sqlca.
What is db2 optimizer?
Why do we bind in db2?
How to find the maximum value in a column in the db2 database?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the cobol picture clause of the db2 data types date, time, timestamp?
