Combine rows from multiple tables and retain duplicate rows.
An UNION ALL construct contains a UNIONA node and at least one subtree. Subtrees denote any source query blocks.
Modify rows in a table.
An update construct contains one UPDATE node and one of the following: single-index access, multiple-index access construct, or table space scan.
Represents UPDATE WHERE CURRENT OF CURSOR value.
Scan a work file.
A work file scan construct contains a WFSCAN node plus a work file node that is labeled WORKFILE.