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 copy book?

1 Answers   Thomson Reuters,

---

What is an instance database?

0 Answers  

---

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---

What are catalog tables in db2?

0 Answers  

---

How can you classify the locks in db2?

0 Answers  

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

What is the difference between Primary key and unique index?

6 Answers  

---

Name the various locking levels available?

0 Answers  

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---