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.