Answer / s

The lock is held as long as the cursor is positioned on the
page or row. The lock is released once the cursor moves to
another page or row.

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

How do I start db2 in windows?

0 Answers  

---

What happens in bind step in a db2 program?

0 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 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,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

What is a DB2 access path?

1 Answers  

---

Which component is used to execute the sql statements?

0 Answers  

---

How does cobol compile db2 program?

0 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---