Answer / s

Information about recovery.

What is db2 stogroup?

0 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

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  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

How will you return the number of records in table?

0 Answers  

---

What are the bind parameters ibm db2?

0 Answers  

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

How are write I/Os from the buffer pool executed?

1 Answers  

---