Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions of Bind?
- 2 Answers
- 8572 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 a bind card?
What is multi row fetch in db2?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Is there any advantage to denormalizing DB2 tables?
What are the three types of page locks that can be held?
Describe the elements of the SELECT query syntax?
what is + sign and -ve sign for sql code ?
what is Runstats? Whem will u choose to runatats?
What is index in db2?
How do you check for a null value in a db2 column?
COBOL 
