DBCREATE_INDEX_OPTS=

Specifies DBMS-specific syntax to be added to the CREATE INDEX statement.

Category: Index Control
Data source: ODBC

Syntax

DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses'

Arguments

DBMS-SQL-clauses

specifies one or more DBMS-specific clauses that can be appended to the end of an SQL CREATE INDEX statement.

Details

This option enables you to add DBMS-specific clauses to the end of the CREATE INDEX statement. The interface passes the CREATE INDEX statement and its clauses to the DBMS, which executes the statement and creates the DBMS index.

Example

In the following example, a Hive index is created with the value of the DBCREATE_INDEX_OPTS= “as 'compact' with deferred rebuild” option appended to the CREATE INDEX statement:
create index "COL1_1A03" on "TKTS002_1A03"{options DBCREATE_INDEX_OPTS="as 'compact' 
with deferred rebuild"}("COL1")
The following CREATE INDEX statement is passed to the DBMS in order to create the index:
create index 'COL1_1A03' on table 'TKTS002_1A03'('COL1') as 'compact' with
deferred rebuild
Last updated: February 23, 2017