Interested to Buy Any Domain ? << Click Here >> for more details...
I understand Join always perform better than subqueries.
Then what is the advantage/use of Subqueries/correlated
subqueries etc.,in DB2 programming.Please explain.
- 0 Answers
- 2059 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is bind plan?
How does a cursor work?
What is a synonym? How is it used?
What is the use of dclgen in db2?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
When is the access path determined for dynamic SQL?
Can one database have multiple instances?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
When is the skeleton cursor table created?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
what is the difference between declaring the cursor in WS section and Procedure division?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
COBOL 
