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 |
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. |
|
|
Data |
NOT |
F |
|
|
int |
X |
|
Artificial primary key. |
|
varchar(30) |
|
X |
Which subsystem or NULL for DB level. |
||
varchar(30) |
X |
X |
The configuration option. |
||
|
smallint |
X |
|
Running number for subsystem/property. |
|
varchar(30) |
|
|
Name for Macro/Undef. |
||
|
nvarchar(4000) |
|
|
Setting for the option. |
|
Name |
Columns |
Options |
PK |
pk_ap_cos |
cosid | nonclustered |
X |
ak_ap_cos |
subsystem, property, valueno | clustered |
|
Artificial primary key. The actual key is (subsystem, property, valueno), but as subsystem may be NULL, this cannot be the primary key. |
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:
* Crypt / -crypt * Environment / -environment * Macro / -Macro * Quote_replace / -quoterepl * Site / -site * 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 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. |
Parent Table |
Foreign Key Columns |
property |
|
subsystem |
|
|
|