What are the 4 environments which can access DB2 ?

2 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---

What will the FREE command do to a plan?

2 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is a DBRM, PLAN ?

3 Answers  

---