Answer / s

Correlation name is defined in the FROM clause as a short
name for the table in the query

SELECT * FROM DSND810.EMP X
WHERE X.EMP = '0010'

X is the correlation name for DSND810.EMP

What is scrollable cursor in db2?

0 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

---

what are the bind parameters?

5 Answers   IBM,

---

How to check sequence on a table in db2?

0 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

Explain correlated sub-queries.

0 Answers  

---

What is meant by explain?

0 Answers  

---

What is a clustering index?

2 Answers  

---

Is db2 a programming language?

0 Answers  

---