Interested to Buy Any Domain ? << Click Here >> for more details...
How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 7543 Views
- I also Faced
- E-Mail Answers
Answer / s
For every qualifying row in the outer query the correlated
subquery is evaluated. The correlated subquery has
reference to atleast one column of the outer query.
Non-correlated subquery does not make any reference to the
other query. The subquery is only executed once and the
results are used by the outer query to find the qualifying
rows.
| Is This Answer Correct ? | 7 Yes | 1 No |
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Which isolation level provides highest data integrity?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What technique is used to retrieve data from more than one table in a single SQL statement?
What is an asychronous write?
What are the contents of dclgen?
What is SPUFI?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is a SELECT statement?
Describe the elements of the SELECT query syntax?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What is a synonym? How is it used?
COBOL 
