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

How to take backup of table in db2?

0 Answers  

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

What is the meaning of -805 SQL return code?

3 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

How to create backup table in db2?

0 Answers  

---

What is index in db2?

1 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---