IDMS: How to recreate the DEFAULT INDEX of an SQL TABLE

book

Article ID: 207613

calendar_today

Updated On:

Products

CA IDMS

Issue/Introduction

By default, when an IDMS SQL table is created, a "default" index is also created.
This default index uses the rows' ROWID (database key) as the symbolic key of that index.
Also, at that time, the table's location mode is set to be VIA that default index (speaking in network terminology).
The reason for this is that in the event that nothing else is added to the table definition which allows IDMS to use another location mode for the table, we will still be able to access all rows of the table efficiently via the default index.
It is common practice to then, before any rows have been added, CREATE a CALC KEY for the table (or some clustering CONSTRAINT) and DROP that default index.

ALTER TABLE schema.table DROP DEFAULT INDEX;

The question is ... is it possible to re-create the default index?

Environment

Release : All supported releases
Component : CA IDMS/SQL Option

Resolution

Yes, it is.
Use the following syntax:

ALTER TABLE schema.table ADD DEFAULT INDEX;

Additional Information

ALTER TABLE