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  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

How to find primary key of a table in db2?

0 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

Give a brief description of db2 isolation levels?

0 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

What is CHECK PENDING ?

5 Answers  

---

What are the contents of a dclmgen?

0 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

What is a synonym ?

2 Answers  

---