Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

INLIST

Welcome > SQL Operations > INLIST

Denotes the in-memory table that stores IN-list elements.

 

INSERT

Welcome > SQL Operations > INSERT

Insert rows into table or view.

The insert construct contains two nodes: one INSERT node and one node that represents either the target view or table.

 

INTERSECT

Welcome > SQL Operations > INTERSECT

Denotes the INTERSECT operation.

This node returns rows in both the inner and outer tables and eliminates redundant duplicate rows.

 

INTERSECTA

Welcome > SQL Operations > INTERSECTA

Denotes the INTERSECT ALL operation.

This node returns rows in both the inner and outer tables and retains redundant duplicate rows.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation