Skip to content

Edit Database Settings

Edits the database settings. The settings are saved in the control file of the database (Control.txt).

Permissions

Command KindNeeded User Kind
SystemAdmin, Sys

Parameters

NameTypeDescriptionRequiredDefaultValues
CatalogbooleanIf 'True' the database is visible in the 'Show Database Catalog' command. The default value is 'False'.nofalse
OffsetMonthintegerIf the fiscal year does not start in january, its start month must be set (1=jan. till 12=dec.) The default value is '1' (jan.).no11, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
SaveEnabledbooleanIf 'True' the database can be saved. The default value is 'True'. This is a temporary value that is not saved in the database settings.notrue
WebDirectorystringProtects a web service directory with 'BasicAuth'. If a value is set, a valid username and password of the database must be used to access the web service directory. E.g. '/MyFiles/SecretFiles/' protects a directory and '/' protects the whole web service.no

Result

NameTypeDescription
CatalogbooleanIf 'True' the database is visible in the 'Show Database Catalog' command.
OffsetMonthintegerStart month of the fiscal year (1=jan. till 12=dec.).
SaveEnabledbooleanIf 'True' the database can be saved. It is a temporary value that is not saved in the database settings.
WebDirectorystringProtects a web service directory with 'BasicAuth'. If a value is set, a valid username and password of the database must be used to access the web service directory. E.g. '/MyFiles/SecretFiles/' protects a directory and '/' protects the whole web service.

Code

text
EDIT DATABASE SETTINGS
CATALOG=[boolean, default=false]
OFFSETMONTH=[integer, default=1, values=[1,2,3,4,5,6,7,8,9,10,11,12]]
SAVEENABLED=[boolean, default=true]
WEBDIRECTORY=[string]