Answer / ms.stanley

WHERE is used to specify the SEARCH ARGUMENT Values in the
SQL Query to retrieve only selected Data from the DB2 Table

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What types of tables are there in the db2 database?

0 Answers  

---

Define buffer pool.

0 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

List out the data types available.

0 Answers  

---

What are the three types of page locks that can be held?

1 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is dbrm? What it contains?

0 Answers  

---

What is a root page?

1 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---