What does the sqlcode of -818 pertain to?

3 Answers  

---

What is a DBRM, PLAN ?

3 Answers  

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

Name the various locking levels available?

0 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

How do I delete a column in db2?

0 Answers  

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What is a clustering index?

2 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

When is the skeleton cursor table created?

1 Answers  

---