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