Answer / ereshwari

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

What is an instance database?

0 Answers  

---

Explain the use of the WHERE clause?

1 Answers  

---

what is REORG? what is the use?

4 Answers  

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

How to see the structure of db2 table??

4 Answers   IBM,

---

what is cursor stability?

2 Answers   IBM,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

How can you find out the # of rows updated after an update statement?

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  

---