If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

Explain what are the various isolation levels possible?

0 Answers  

---

What is meant by isolation level?

3 Answers  

---

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  

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What is the use of runstats in db2?

0 Answers  

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---