Answer / s

To reset pending flags on tablespace
SET NOCHECKPEND

What is the difference between drop table and delete table?

0 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

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

4 Answers   IBM,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What are host variables in db2?

0 Answers  

---

What is precompiler in db2?

0 Answers  

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

What is referential integrity?

5 Answers  

---