What are host variables in db2?

0 Answers  

---

What do you mean by commit and rollback?

0 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

How many buffer pools are there in DB2?

2 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 the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

What is buffer pool?

0 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

What is syscat in db2?

0 Answers  

---

What is lock contention?

1 Answers  

---