Answer / vat

Absolutely! Just look at the catalog table SYSIBM.SYSPLANDEP

It's pretty straight forward! It recrods the dependencies
of plans on tables, views, synonyms, table spaces, indexes,
aliases, functions and stored procedures.

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

---

How does DB2 store NULL physically?

2 Answers  

---

What does DSNDB07 database do?

2 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---

What is IMAGECOPY ?

6 Answers  

---

What is query_cache_limit?

0 Answers  

---