Interested to Buy Any Domain ? << Click Here >> for more details...
What is a correlated sub query?
- 2 Answers
- 5460 Views
- I also Faced
- E-Mail Answers
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 |
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
How to find primary key of a table in db2?
What is an instance database?
How do you find the maximum value in a column in db2?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the maximum No of rows per page?
Which component is responsible for processing sql statements and selecting access paths?
What is rebind in db2?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
In a DB2-CICS program which is acts as co-ordinator and which is participant?
What is collection in db2 bind?
COBOL 
