Answer / hari143

no

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What do you mean by cursor?

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

What is db2? Explain.

0 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

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,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

Explain about rct in db2?

0 Answers  

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

How does DB2 store NULL physically?

2 Answers  

---