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;

Note: It is most efficient to load the required database before you run the SETDBSTATE command, then stop and restart the database for the command to take effect.

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 designer.
dataCacheSize Maximum amount of memory allocated for data cache. Default: 3145728 bytes.
Y/N Sets whether to aggregate missing values.
Y/N Sets whether or not 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

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";
	

See Also

SETDBSTATEITEM

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com