What are the functions of Bind?
- 2 Answers
- 7166 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 collection in db2?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How to access db2 tables in mainframe?
How many buffer pools are available in db2?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What do you need to do before you do EXPLAIN?
What are the three DB2 date and time data types and their associated functions?
How can you quickly find out the # of rows updated after an update statement?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a trigger in the db2 database?
What do you need to do before you do EXPLAIN ?
What is dbrm?
COBOL 
