Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions of Bind?
- 2 Answers
- 8439 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 |
Where are plans stored?
What DB2 Catalog column tell you when an index needs table reorganized ?
In which column of which DB2 catalog would you find the length of the rows for all tables?
Explain the use of the WHERE clause?
When reorg is used?
How is deadlock resolved?
What is dbrm in db2 database?
What is the information associated with sysibm.syslinks table?
How can you quickly find out the # of rows updated after an update statement?
What is a cursor?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
COBOL 
