CRIX (CREATE Index SQL)
The CRIX row command generates SQL to create an index. This command is valid for tables. When CRIX is executed, File-AID for Db2 Object Administration opens object editing windows for the new index. Edit the attributes and press <Go> to generate the SQL.
See CR-CREATE-SQL to create an index like a displayed index.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*