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?
Release : All supported releases
Component : CA IDMS/SQL Option
Yes, it is.
Use the following syntax:
ALTER TABLE schema.table ADD DEFAULT INDEX;