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.
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.