Answer / guest

Includes unmatched rows from both tables. If any column of
the result table does not have a value, that column has the
null value in the result table.

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What is a result table?

1 Answers  

---

What does reorg do in db2?

0 Answers  

---

How is a typical db2 batch pgm executed?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

what is consistency token

3 Answers  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 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 is the advantage in De-normalizing tables in DB2?

0 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---