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 the purpose of the QUIESE Utility?

1 Answers  

---

What is bufferpool in db2?

0 Answers  

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

how 2 resolve the -311 sqlcode

1 Answers  

---

Update command

1 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

What is pagespace?

1 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,

---

What will the COMMIT accomplish?

5 Answers  

---

How do I delete a table in db2?

0 Answers  

---