what is a trigger and types of triggers

3 Answers   HSBC,

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

What is the usage of open cursor command?

0 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

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

5 Answers   Emsang,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

Name the different types of Table spaces.

5 Answers   IBM,

---

What are the Isolation levels possible ?

5 Answers  

---

How can deadlocks be resolved?

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---