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 do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

What is the difference between Primary key and unique index?

6 Answers  

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

How many clustering indexes can be defined for a table?

2 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

How do you define a correlated name?

1 Answers  

---

What is isolation level?

4 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---