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.
Denotes a work file or temporary table that DB2 generates.
DB2 labels a work file node with the word WORKFILE or with specific name. Sort (for JOIN, UNION, DISTINCT, GROUP BY, or ORDER BY operations) is the most common operation for generating work files.
