Specific CREATE INDEX clauses

In addition to the standard index-key specification using a column list, the CREATE INDEX statement supported by IBM® Informix® SQL allows specific clauses, for example to define storage options.

Genero BDL partially supports the CREATE INDEX statement; the following are not supported in static SQL grammar:

• The IF NOT EXISTS clause.
• Functional index specification is not allowed in the index-key list.
• Storage options such as IN dbspace, EXTEND SIZE, NEXT SIZE.
• The index mode clauses such as FILTERING WITH/WITHOUT ERROR.
• The USING clause.
• The HASH ON clause.
• The FILLFACTOR clause.

You can use Dynamic SQL to execute CREATE INDEX statements with clauses that are not allowed in the static SQL grammar.