Embedded Usage
In an embedded CREATE INDEX statement, the following elements can be replaced with host language variables:
location_name
Specifies the location of the index; must be a string variable.
N
Specifies fill and page values; must be an integer variable.
The preprocessor does not validate the WITH clause syntax. The WITH clause can be specified using a host string variable (with :hostvar).