Answer / s

Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause

WITH UR;

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

What are db2 tables?

0 Answers  

---

---

What does an outer join do?

1 Answers   CTS,

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

Discuss about db2 bind?

0 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,

---

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

0 Answers  

---

What is the difference between spufi and qmf?

0 Answers  

---