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.

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

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

3 Answers   IBM,

---

Define data page.

0 Answers  

---

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

2 Answers   IBM,

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---

---

Can there be more than one cursor open for any program?

0 Answers  

---

Is db2 relational database?

0 Answers  

---

Name the various locking levels available?

0 Answers  

---

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?

2 Answers   Deloitte,

---

What is usage pointer in cobol?

3 Answers   IBM,

---

What is cursor in dbms?

0 Answers  

---

What is a recovery log?

1 Answers  

---