SQL guide For IBM Informix database servers 5.x, 7.x, 8.x, 9.x, 10.x, 11.x / Partially supported IBM Informix SQL features |
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:
You can use Dynamic SQL to execute CREATE INDEX statements with clauses that are not allowed in the static SQL grammar.