Subquery support with DB2^® Multisystem

 

Distributed files can be specified in subqueries.

A subquery can include search conditions of its own, and these search conditions can, in turn, include subqueries. Therefore, an SQL statement can contain a hierarchy of subqueries. Those elements of the hierarchy that contain subqueries are at a higher level than the subqueries they contain.

 

Parent topic:

Query design for performance with DB2 Multisystem

 

Related concepts

SQL programming