SETDBSTATE

Defines database settings. For more options, see SETDBSTATEITEM.

Syntax

SETDBSTATE ["appName"] ["dbName"] "desc" Y/N Y/N accessLevel
  dataCacheSize Y/N Y/N Y/N currDb ccType 0/1 indexCacheSize
  IndexPageSize Y/N;

Parameter	Description
appName	Name of the application. Do not include if the application is already selected.
dbName	Name of the database; required if appName is specified.
desc	Text string describing the database.
Y/N	Sets whether the database is loadable.
Y/N	Sets autoload on or off.
accessLevel	Default access level. Values: 0 - None. 1 - Read. 2 - Write. 3 - Calculate. 4 - Database Manager.
dataCacheSize	Maximum amount of memory allocated for data cache. Default: 3145728 bytes.
Y/N	Sets whether to aggregate missing values.
Y/N	Sets whether to perform a Two-Pass calc.
Y/N	Sets whether to create blocks on equations.
currDb	Links a currency database.
ccType	Specifies the default currency type member.
0/1	Sets the conversion method. Values: 0 - Division. 1 - Multiplication.
indexCacheSize	Maximum amount of memory allocated for index cache. Default: 1048576 bytes.
indexPageSize	Maximum amount allocated for index page. Index page size is now fixed at 8192 bytes regardless of this setting.
Y/N	Enable (Y) or disable (N) data compression on disk.

Notes

Using the semicolon statement terminator (;) is optional in ESSCMD scripts. However, it is good practice to use it to signal the end of the SETDBSTATE parameter list. This is especially important if you omit some of the parameters, accepting their default values. If not all parameters are present, and the ; is omitted, ESSCMD looks for the remaining values in the next line, leading to unpredictable results.
If you issue only the SETDBSTATE keyword in interactive mode, ESSCMD prompts you for the other values.
Load the required database before you run the SETDBSTATE command, then stop and restart the database for this command to take effect.

Example

The following example assumes that the application and database are already selected. Settings that you want to skip need to be represented using empty quotation marks as placeholders.

SETDBSTATE "Data has been updated" "Y" "Y" 4 "3000000"
    "N" "Y" "N" "" "" 0 "1049000" "8192" "Y";