What is a DB2 bind?
Answer / tintu raveendran
It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.
Is This Answer Correct ? | 8 Yes | 2 No |
i want to maintain uniqueness on pdf without make lf??????????
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
Define data page.
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What should be specified along with a cursor in order to continue updating process after commit?
Can there be more than one cursor open for any program?
Is db2 relational database?
Name the various locking levels available?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is usage pointer in cobol?
What is cursor in dbms?
What is a recovery log?