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
- 13724 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
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What's The Error Code For Unique Index Voilation?
What is the physical storage length of time data type?
What is cascading rollback?
What is image copy in db2?
What is difference between isnull and coalesce?
Why db2 is called db2?
How does coalesce work?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the difference between using bind () and rebind () methods of naming class?
Is the primary key a clustered index?
What is the usage of open cursor command?
Explain the contents that are a part of dclgen.
What is load replace in db2?
What is db2?
