abaconfigsettings (ap_cos)

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, 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.

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

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.

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

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:

* Ansi_defaults / -Adefaults
* Ansi_nulls / -Anulls
* Ansi_padding / -Apadding
* Crypt / -crypt
* Environment / -environment
* Macro / -Macro
* Quoted_id / -Aquoted
* Quote_replace / -quoterepl
* Site / -site
* Subscriber / -subscriber
* Undef / -undef

Running number for this combination of subsystem/property.

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 for the config options. Here is how to fill in the value for the various options:

For Crypt and Subscriber: 1 to specify -crypt/-subscriber and 0 for -nocrypt/-nosubscriber.

For Site and Server_CS: the argument you would give to -site/-charset.

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.