Changing File Attributes for File Names Matching a Pattern Using changeda

The changeda -p option allows you to change attribute values for all files in a data area whose names match a regular expression.

To change file attributes for files matching a business class pattern

At a Landmark command prompt, type

changeda -p[r] [attribute=value] [-v displayoptions] dataarea [filename_pattern ]

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 files or modules in the specified data area.
`dataarea`	The data area to change file attributes for.
`filename-pattern`	A regular expression that matches one or more LPL file names.
`-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

Example: Setting an Attribute For Files that Contain a Pattern

The following command sets the default space attribute value to lazyspace for files in the data area myproduct whose names contain the phrase "U_":

changeda -p space="lazyspace" myproduct U_*

When this statement is implemented, the Unique ID files for classic tables created by the Lazy Unique ID pattern will all be placed in the database space called lazyspace.