The derived table allows the FROM list to specify a spool file composed of selected data from underlying tables. The derived table acts like a viewed table.
Derived tables are valid when coded as part of a seed query.
Derived tables are never valid when coded as part of a recursive query.
See SQL Data Manipulation Language, B035-1146 for complete documentation of derived tables.