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
- 13629 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 null indicator in db2?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
what is SMP/E? and what are the major steps of it? thanks...
What is cursor with hold option in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
how to unload different table data into different gdg files/ vsam files.
What are the various locking levels available?
Why do chiropractors use drop table?
wt is view ? wht r the restrictions for view ?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How can you do the explain of a dynamic sql statement?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
COBOL 
