If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

What is cascading rollback?

0 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

What is dynamic SQL?

1 Answers   ADP,

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

What are the bind parameters ibm db2?

0 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---

What is deadlock in db2?

0 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---