Answer Posted / 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)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to access db2 tables in mainframe?
What is check constraint. Explain with example.
How to create db2 table in mainframe?
Define sqlca.
What is a db2 package?
can all users have the privilage to use the sql statement select * (dml)?
What is difference between rollback and commit?
Define buffer pool.
What is the physical storage length of timestamp data type?
What is meant by dclgen?
How to fetch the last row from the table in SQL (db2)?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What does db2 blu stand for?
Is db2 a mainframe database?
What is the function of logging in the db2 database?