what is a corelated subquerry?

0 Answers   IBM,

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

Define sqlca.

0 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What is cursor stability?

1 Answers  

---

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,

---

What is load replace in db2?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

What are the uses of db2 optimizer?

0 Answers  

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---