Writing Script Files

ESSCMD script files automate an often-used or lengthy series of commands. Each script file must be a complete ESSCMD session, with login, application and database selection, logout, and termination commands.

  To define a script file:

  1. Enter ESSCMD commands in any editor that saves data in ASCII text.

  2. Save the file with the .scr ESSCMD script file extension.

    For example, the following script file, test.scr, was created in Notepad:

    LOGIN "localhost" "User1" "password";
    SELECT "Sample" "Basic";
    GETDBSTATE
    EXIT;

When run from the operating system command line, this script logs User1 into the Essbase localhost server, selects the Sample application and Basic database, gets database statistics, and quits the ESSCMD session.