Answer Posted / 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 |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is copy pending status in db2?
What is a trigger in the db2 database?
What is dbrm library?
What is the difference between cursor stability and repeatable read isolation levels?
What are the various isolation levels possible?
What is scrollable cursor in db2?
Can we update view in db2?
Are view updateable?
What is a db2 tablespace?
Why cursor is used in db2?
How to restart a DB2 program?
Is db2 a programming language?
What is the role of schema in the db2 database?
What is image copy in db2?