Answer Posted / md amanullah

Where Clause:
1)WHERE clause can be used without GROUP BY clause.
2)WHERE clause select rows before grouping.
3)WHERE clause can not contain aggregate functions.
4)WHERE clause can operate individual row.
5)It is more fast.

Having Clause:
1)HAVING clause can not be used without GROUP BY clause.
2)HAVING clause select rows after grouping.
3)HAVING clause can contain aggregate functions.
4)HAVING clause can operate group of row.
5)It is much slow.

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1975

---

What is buffer pool in the db2 database?

1046

---

Define db2.

1064

---

What are iseries servers?

1009

---

How can you do the explain of a dynamic sql statement?

1013

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2312

---

What is the use of db2 optimizer?

1036

---

What is the use of value function?

1074

---

Explain the function of data manager.

990

---

What is the maximum number of columns in a db2 table?

1214

---

What is bind and rebind in db2?

1072

---

What is the difference between nvl and coalesce?

1009

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102

---

What is load replace in db2?

935

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1309

---