Answer / amarnadh reddy

If we set SQLCODE=100 means end of the table.

EX: if sqlcode=100
Display end of the table
end-if.

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

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

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

Is ibm db2 open source?

0 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

What are the various isolation levels possible?

0 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---