Answer / mounikag

To select the records dynamically during runtime.
In the file level define DYNSLT.

How to compare data between two tables in db2?

0 Answers  

---

What is a storage group (stogroup)?

0 Answers  

---

What is a view? Why use it?

3 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

How do you select a row using indexes in db2?

0 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is the self-referencing constraint?

2 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---