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 technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What are packages in db2?

0 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

What is a collection in db2?

0 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is copy pending status in db2?

0 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

---