What is a correlated sub query?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / aditya
a query in which there is reference of inner query into
outer query and that of outer query into inner
query...means they can't run independently.
Is This Answer Correct ? | 2 Yes | 1 No |
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What do you mean by NOT NULL? When will you use it?
How would you find out the total number of rows in a db2 table?
what is the use of bind parameter, Replace?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What does the REORG Utility do?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is PRIME TABLE and what are the uses of it
What is image copy?
what is the sqlcode -501
cursor with hold explain ?