Changing File Attributes with Matching Business Class Patterns Using changeda

The changeda -b option allows you to change attribute values for all files in a data area whose contain a business class pattern.

To change file attributes for files matching a business class pattern

At a Landmark command prompt, type

changeda -b[r] [attribute=value] [-v displayoptions] dataarea [businessclass_pattern ...]

changeda --listbusclasspatterns

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
--listbusclasspatterns Lists the available business class pattern names for use with the -b (--busclasspattern) option.
-r Remove files or modules in the specified data area.
dataarea The data area to change file attributes for.
businessclass-pattern The pattern that determines which files' attributes are modified.
-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