Answer / s

Data Manager evaulates the Stage 1 Predicates on the data
in the bufferpool. It also interfaces with the index
manager for index processing. Data Manager does tablespace
scans. The DM passes the qualifying rows are one column at
a time the Relational data manager.

Answer / renu gupta

Data Manager manages the physical databases by performing
all the normal access method functions

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

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

0 Answers  

---

What are PACKAGES ?

3 Answers  

---

What is nvl in db2?

0 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What will the DB2 optimizer do?

2 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---