Answer Posted / guest
Correlated subquery process is an outside-inside-outside
subquery. For every row in the outer query the inner query
is evaluated and results passed to the outer query to
complete the final result row.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by cursor?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are the uses of db2 optimizer?
Explain what are the various isolation levels possible?
Mention the location where the output received from explain statement is stored.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is multi row fetch in db2?
What is explain in db2?
What kind of database is db2?
How do I add a column to an existing table in db2?
How do I add a column to a table in db2?
Why do we use cursor?
How can we read records for specific member in CL? AND rpg?
What is database reorganization?
What is commit in db2?