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]