What are the functions of Bind?
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 are the full forms of spufi and dclgen and why are they used?
How to check last update on table in db2?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Explain what are the various isolation levels possible?
how to resolve -805 . how to see dbrm and package not found
What is the difference between plan and package in db2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is null in db2?
what is the use of commit ? and what is the syntax?
What is package in db2 mainframe?