Answer / ereshwari

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

What is a page in db2?

0 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  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

---

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

1 Answers   Hewitt,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

What is the use of db2 optimizer?

0 Answers  

---

Define db2 and its databases?

0 Answers  

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

what is sql abend code -801,-802?

2 Answers  

---