Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

RETURN

Welcome > SQL Operations > 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

Welcome > SQL Operations > REPARTITION

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

 

RGLIST

Welcome > SQL Operations > RGLIST

Use to perform a range-list Scan.

 

RIDFETCH

Welcome > SQL Operations > RIDFETCH

Use built-in RID function for access.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating