Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

RETURN

Auxiliary node that represents an entire SQL statement.

Labeled QUERY, this node can represent any of the following operations:

  • MERGE
  • INSERT
  • SELECT
  • UPDATE
  • DELETE

 

REPARTITION

Re-partition multiple input data streams for multiple output data.

 

RGLIST

Use to perform a range-list Scan.

 

RIDFETCH

Use built-in RID function for access.

 

Related Documents