how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

How to execute stored procedures?

0 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

What is database reorganization?

0 Answers  

---

Compare a subselect to a join?

1 Answers  

---

What is the latest version of ibm db2?

0 Answers  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---