A.19 Statements Related to Using OLAP_TABLE in SQL

Table A-30, "Statements Related to OLAP_TABLE " lists the OLAP DML statements that support the use of the OLAP_TABLE function.

Table A-30 Statements Related to OLAP_TABLE

Statement	Description
FETCH	Specifies how analytic workspace data is retrieved for use in the relational table created by the OLAP_TABLE function which you use to access analytic workspace data using SQL.
GROUPINGID	Populates a previously-defined variable with the grouping ids for the values of a hierarchical dimension.
HIERHEIGHT command	Populates a previously-defined relation with the values of a specified hierarchical dimension by level.
LIMITMAPINFO	Returns the analytic workspace expression that a specified limit map uses to map data into a specified column of a relational table.