Answer / s

Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.

Answer / harsha

cursor is used to retrive multiple rows.

What is a lock?

1 Answers  

---

why we create view.

5 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

How to find primary key of a table in db2?

0 Answers  

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

How do I copy a table in db2?

0 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

---