Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions of Bind?
- 2 Answers
- 8428 Views
- Amdocs, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha dasari
there are three things bind does:
1. as stated above, it derives the most optimised path for
each SQL in the DBRM.
2. it does a syntax check. this might sound redundant, but
here is where it refers to the DB2 Catalog and verifies the
table names, column names etc.
3. it checks authorization. here is where it checks if the
user has bind access to the table refered.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ms. stanley
To create the most optimal path for the SQL Queries in the
program
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the physical storage length of timestamp data type?
How to resolve -805 error in DB2?
What can the Locate option of the Repair Utility accomplish?
When would you prefer to use VARCHAR?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What do you need to do before you do EXPLAIN ?
can all users have the privilage to use the sql statement select * (dml)?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is meant by the attachment facility?
Outputs of explain are with matchcols = 0. What does this signify?
What is the maximum No of rows per page?
What is a cursor?
COBOL 
