Answer Posted / s
Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is null indicator in cobol db2?
List some fields from sqlca?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How can deadlocks be resolved?
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 db2 look?
Where do you specify them?
What is buffer pool?
Comment whether the cursor is closed during commit or not.
What is explain plan in db2?
What is schema in db2?
Give the name of some fields form sqlca.
What is the max length of sqlca?
How do you find the maximum value in a column in db2?
What is blu acceleration in db2?
