Only IQ index types can be created on IQ tables within a Parallel IQ block.
Item |
Value |
---|---|
SQLCode |
-1008030 |
Constant |
EMSG_SQL_PLBEGINONLYCI |
SQLState |
QNA30 |
ODBC State |
ERROR |
The BEGIN PARALLEL IQ...END PARALLEL IQ statement allows users to group multiple CREATE INDEX statements for execution at the same time. Only CREATE INDEX statements for HighGroup, HighNonGroup, LowFast, LowDisk, CMP, DATE, TIME, and WD index types on IQ tables are allowed within the BEGIN PARALLEL IQ...END PARALLEL IQ statement.