Using SETDBSTATEITEM in ESSCMD

For simple items, specify the command, item number representing the parameter, application, database, and value for the parameter:

SETDBSTATEITEM 2 "SAMPLE" "BASIC" "Y";

For parameters that require multiple values, such as Isolation Level (item 18), specify multiple values; in this case, all the values after “BASIC”:

SETDBSTATEITEM 18 "SAMPLE" "BASIC" "1" "Y" "-1";

If you do not know the parameter number, omit it, and Essbase lists all parameters and their corresponding numbers. Essbase also prompts you for a database and an application name.

Use a separate SETDBSTATEITEM command for each parameter; you cannot string parameter numbers together on the same line.

See the Oracle Essbase Technical Reference for information about the parameters for the SETDBSTATE and SETDBSTATEITEM commands.

Note:

SETDBSTATEITEM or SETDBSTATE affects only the specified database.

You can include SETDBSTATEITEM (or SETDBSTATE) in batch scripts. For a comprehensive discussion of batch processing, see Using Script and Batch Files for Batch Processing. For information on specific ESSCMD syntax, see the Oracle Essbase Technical Reference.