Changing Index Attributes Using changeda

The changeda -i option allows you to change attribute values for specified indexes within the data area. For example, you can specify whether an index is a virtual or physical index.

Note that you can convert all virtual indexes to physical indexes using the procedure outlined in Converting Virtual to Physical Indexes.

To change index attributes

At a Landmark command prompt, type

changeda -i[r] [attribute=value] [-v displayoptions] dataarea file index ...

where the default data area attribute that can be changed is:

Attribute Value
indexed

Yes or no.

Specifies whether a physical index should be created on the database server. The default is to obey the indexed attribute in the business class definition.

A value of yes indicates that the physical index should be implemented on the server. A value of no specifies that this index is a virtual index.

ddloptions The ddloptions attribute enables you to include a string with valid DDL statements. This replaces the functionality formerly provided by LAW_DBA_TABLES.

Other values in the command syntax are:

Entry Description
-r Remove rather than update the attribute.
dataarea The data area to change index attributes for.
file The file to change index attributes for.
index The index to change attributes for.
-v displayoptions

errorlevel, tracelevel, and verbose specified in any order, where:

  • errorlevel = {n}none | {f}atal | {e}rror | {w}arning (warning is the default)

  • tracelevel = 0:6 where 0 is no message and 6 is everything

  • verbose = whether to display exception stacktrace