Changing Database File Attributes Using changeda

The changeda -f option allows you to change attribute values for specified files within the data area.

To change file attributes

At a Landmark command prompt, type

changeda -f[r] [attribute=value] [-v displayoptions] dataarea [files...]

where the default data area attributes that can be changed are:

Attribute Value
space A valid database space name to contain the file.
varchar

Enter yes to specify that the database driver should use a var char rather than a char type for the Lawson Alpha, AlphaUpper, and AlphaRight data types.

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

If you set this to true, LOBs will be placed in separate tables and these tables will not be included in a database reorganization unless necessary. For a new installation, the default value of this attribute is true. For systems being updated from pre-10.0.0.2 Landmark, you must run changeda to set the value to true.

For more information on how to convert to using split LOB storage, see Converting to Split LOB Storage.
pmyincludedeleteflag If you set this to true, the system more efficiently processes searches against primary indexes that have deleted records. For a new installation, the default value of this attribute is true. For systems being updated from pre-10.0.0.2 Landmark, you must run changeda to set the value to true.

Other values in the command syntax are:

Entry Description
-r Remove file(s) in the specified data area.
dataarea The data area to change file attributes for.
files One or more files 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