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
What is the maximum length of sqlca?
Are views updateable?
How can the duplicate values be eliminated from db2 select?
What are the uses of db2 optimizer?
How can we retrieve the total number of records in RPG & CLLE?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What action db2 takes when a program aborts in the middle of a transaction?
What is query_cache_limit?
Name the various locking levels available?
Explain various types of locks in 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 is the use of with ur in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the result of open cursor statement?
What is an instance in db2?
