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
- 13617 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 |
select distinct(empid),distinct(dept),name from EMP will the above query work?
When is the results table for the query in a DECLARE CURSOR statement created?
What is rct?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What is the difference between drop table and delete table?
What is difference between rollback and commit?
What is a collection in db2?
What is an access path?
what is + sign and -ve sign for sql code ?
How to select the duplicate rows from a table?
What is a clustering index?
How do I import a csv file into db2?
COBOL 
