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.

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

What is meant by concurrency?

1 Answers  

---

Explain about open switch business continuity software?

0 Answers  

---

What is dclgen (declaration generator)?

0 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

what is a collection?

2 Answers  

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

What is image copy in db2?

0 Answers  

---

What are db2 tables?

0 Answers  

---