Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

cobol-db2 runjcl please?

2 Answers   DELL,

---

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

0 Answers  

---

What is index cardinality?

3 Answers  

---

What is a data page?

1 Answers  

---

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

what is rebinding ?

1 Answers   IBM,

---

When is the skeleton cursor table created?

1 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

What is ibm db2 connect?

0 Answers  

---