When is the authorization check on DB2 objects done - at
BIND time or run time?
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 |
How will you delete duplicate records from a table?
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
What is the syntax for FETCH in DB2 ?
What is the use of reorg in db2?
Where is the access path logic created by the DB2 Optimizer stored?
What is the difference between Primary key and unique index?
What is collection in db2 bind?
What is null in db2?
Explain about open switch business continuity software?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is deadlock in db2?
What are the three types of page locks that can be held?