Answer / m4io

a cartesian product is a join between two tables where
the join-condition + where-conditions do not deliver a
unique key on either table.
it is a n*m relationship.

Not necessarily faulty (Star joins use cartesian products)

Answer / sunil1405

A Cartesian product results from a faulty query. It is a
row in the results for every combination in the join
tables.

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

What do you mean by cursor?

0 Answers  

---

What is a collection in db2?

0 Answers  

---

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

what is plan? is plan executable or package?

4 Answers  

---

what is utility for parm lib

0 Answers   IBM,

---

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 DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---