SQL/DDL Implementation › Separate View and Index Creation

Separate View and Index Creation

Beginning with Release 5.2 you can specify not to generate an index and also retain *IMMED maintenance capability for the access path on the IBM i. Prior to Release 5.2, if you specified *IMMED maintenance for an SQL access path, SQL DDL to create an index was unconditionally generated into the source member of the access path following the DDL for the view.

In the current implementation of SQL you can:

• Suppress the generation of an index by specifying *NONE or blank for the index name on the Edit Access Path Auxiliaries panel.
• Rename an index.
• Generate an index without a view.
• For DDL implementation, only an index with the same name as source member name is created and view does not get created because, current implementation of DDL allows database access methods of *TABLE only.
• Auxiliaries are not applicable for DDL type file as Views are not created for DDL type file and only Index with the same name as the source member name is created.

A discussion of these capabilities follows.