Answer / ms.stanley

WHERE is used to specify the SEARCH ARGUMENT Values in the
SQL Query to retrieve only selected Data from the DB2 Table

what is a corelated subquerry?

1 Answers   IBM,

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

What is host variable?

1 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

What is DCLGEN?

2 Answers  

---

How can deadlocks be resolved?

1 Answers  

---

What is the use of with ur in db2?

1 Answers  

---

How can record locking be achieved in those DB2 versions which do not support it?

1 Answers  

---

How does cobol compile db2 program?

1 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  

---

Can there be more than one cursor open for any program?

1 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---