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
- 13612 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 |
Outputs of explain are with matchcols = 0. What does this signify?
What is copy pending status in db2?
How to access db2 tables in mainframe?
How do you pull up a query which was previously saved in qmf?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is a clustering index?
What is syscat in db2?
What is release/acquire in bind?
How to create db2 table in mainframe?
What is the difference between using bind () and rebind () methods of naming class?
what is copy pending and check pending ?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
COBOL 
