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

Update command

1 Answers  

---

What do you mean by commit and rollback?

0 Answers  

---

What are types of indexes?

0 Answers  

---

What does db2 mean?

0 Answers  

---

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

How do I add a column to a table in db2?

0 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

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

2 Answers  

---

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

1 Answers   Accenture,

---

What is isolation level?

4 Answers  

---

What is meant by index cardinality?

2 Answers  

---