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

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What is copy pending status in db2?

0 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

---

How do you find the maximum value in a column in db2?

0 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

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

3 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---