DBCREATE_INDEX_OPTS=

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

Category: Index Control
Data source: ODBC
Syntax
Arguments
Details
Example

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
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017