Answer / s

WHENEVER is used to specify whether to continue processiong
or branch to another area in your program.

EXEC SQL
WHENEVER CONDITION ACTION
END-EXEC

CONDITION can be SQLWARNING, SQLERROR, NOT FOUND conditions

The ACTION can be CONTINUE or GO TO to branch to another
area in your program

What is meant by a unit of recovery?

1 Answers  

---

What are foreign keys?

1 Answers  

---

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  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is sqlcode -922 ?

2 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

What is the FREE command?

1 Answers  

---

Which transaction use a command thread ?

1 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

What is difference between isnull and coalesce?

0 Answers  

---