Defines database settings. For more options, see SETDBSTATEITEM.
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. |
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";
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |