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
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?
What is meant by union and union all?
Mention the various locks that are available in db2.
What action db2 takes when a program aborts in the middle of a transaction?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Define db2 and its databases?
How do I add a column in db2?
What is the information associated with sysibm.syslinks table?
How do I import data from excel to db2?
What does sqlcabc has?
What is bind in db2?
How to find the number of rows in a db2 table?
What is db2 bind?