abaconfigsettings (ap_cos)

Name

abaconfigsettings

Code

ap_cos

Creation Date

13 december 2000 13:53:05

Modification Date

15 augusti 2012 13:15:58

Comment

Configuration options on database or subsystem level


Table description

This table holds the configuration options that applies to this database. As discussed on the config-file page, an option can apply on database level, or for a single subsystem only. In the first case the subsystem column is NULL.

 

Note as discussed in the description for abaconfigproperties, the database names for the configuration opions deviates from the ones used in the config-file.

 

The same option can appear more than once for the same entity, although it does not make sense for all options. (For instance it doesn't make sense for Crypt, but it does make sense for Macro.)

 

When you need to change the configuration settings of a database, you can do that with DBBUILD -rebuild/-restruct but there may also be situations when you prefer to update directly, for instance to a add a macro that no existing SQL file is using. You can add a row by a direct INSERT statement, but stored procedure ap_cos_insert_sp makes it a little simpler.


Column list


Column


Domain

Data
Type

NOT
NULL

F
K


Comment

cosid

 

int

X

 

Artificial primary key.

subsystem

ap_subsystem

varchar(30)

 

X

Which subsystem or NULL for DB level.

property

ap_property

varchar(30)

X

X

The configuration option.

valueno

 

smallint

X

 

Running number for subsystem/property.

name

ap_property

varchar(30)

 

 

Name for Macro/Undef.

value

 

nvarchar(4000)

 

 

Setting for the option.


Table constraints

(NOT (property IN ('Macro', 'Undef') AND name IS NULL))


Keys

Name

Columns

Options

PK

pk_ap_cos

cosid nonclustered

X

ak_ap_cos

subsystem, property, valueno clustered

 


cosid

Artificial primary key. The actual key is (subsystem, property, valueno), but as subsystem may be NULL, this cannot be the primary key.

cosid is just a running number, usually set to the next number available.


subsystem

Which subsystem the configuration option applies to. NULL if the option applies on database level.


property

The configuration option we are defining a setting for. Here is the mapping between database names and the names used in the config-file and on the command line, with the database names first:

 

* Crypt / -crypt

* Environment / -environment

* Macro / -Macro

* Quote_replace / -quoterepl

* Site / -site

* Undef / -undef


valueno

Running number for this combination of subsystem/property.


name

This column applies to the Macro and Undef configuration options, and is the name of the macro being defined/undefined. The column is mandatory for these two config-options, and not applicable for the other ones.


value

Value for the config options. Here is how to fill in the value for the various options:

 

For Crypt and Quote_replace: 1 to specify -crypt/-quoterepl and 0 for -nocrypt/-noquoterepl.

 

For Site: the argument you would give to -site.

 

For Environment, one of DEV, TEST or PROD.

 

For Macro: the value of the macro. You can use NULL to specify that the macro is defined with the value of the empty string.

 

For Undef: value is always NULL.


Tables abaconfigsettings refers to

Parent Table

Foreign Key Columns

abaconfigproperties

property

abasubsystems

subsystem