Answer / sadiq afroze

The CHECK Utility checks the referential integrity of table
relations and checks the integrity of the indexes by
matching index column values to table column values.

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,

---

How to design maps

1 Answers   Virtusa,

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

Compare a subselect to a join?

1 Answers  

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

how to resolve -811

2 Answers   IBM,

---

What is host variable in db2 cobol?

0 Answers  

---