サポートと今すぐチャット
サポートとのチャット

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.

 

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択