Answer Posted / prasad

Hierarchy

Plan

Collection of collections is Plan

Collection

Collection of packages is Collection

Package

Collection of items is Package

What is the use of predicate?

1089

---

How do I create a view in db2?

1078

---

What are the 2 sqlcodes that are returned?

1237

---

What is host variable?

1113

---

What is precompiler in db2?

1080

---

What is the physical storage length of timestamp data type?

1151

---

What is the difference between dbm cfg and db cfg file in db2 ?

1594

---

What is reorg and runstats in db2?

1262

---

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

1227

---

How to find the number of rows in a db2 table?

1158

---

What r the comman abends in db2, jcl and cobol???????

2310

---

What is a bind in db2?

1108

---

What are the prerogatives?

1130

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1223

---

How can you quickly find out the # of rows updated after an update statement?

1087

---