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
- 13755 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 are the benefits of using the db2 database?
What are the functions of Bind?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is check constraint. Explain with example.
How does DB2 store NULL physically?
how to unload different table data into different gdg files/ vsam files.
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is data manager?
Explain in brief how does db2 determine what lock-size to use?
Can you tell me how can you find out the # of rows updated after an update statement?
How to fetch the uncommited data from table ?
What is coalesce in db2?
COBOL 
