ESSCMD Command Groups

Overview
Getting Started
Syntax Guidelines
Batch Processing
Interactive Mode
Command Groups
Commands List -- New for Release 6

This section lists ESSCMD commands, grouped by command type:

Using ESSCMD
Application and Database Administration
User/Group Security
Security Filters and Locks
Database Objects
Outline/Attribute Information
Dimension Building
Data Loading, Clearing, and Exporting
Calculating
Reporting

Partitioning
Outline Synchronization
Error and Log Handling
Currency Conversion Information
Location Aliases
Substitution Variables
Aliases
Integrity and Performance
Backing Up

Using ESSCMD

Use these commands to log in and out of ESSCMD, view a list of commands, pause an ESSCMD script, and redirect command output.

Application and Database Administration

Use these commands to perform database administration, and get information about applications and databases.

GETVERSION
CREATEAPP
DELETEAPP
COPYAPP
RENAMEAPP
LISTAPP
LOADAPP
GETAPPACTIVE
GETAPPINFO
GETAPPSTATE
SETAPPSTATE
UNLOADAPP
CREATEDB
DELETEDB
COPYDB
RENAMEDB
LISTDB
LOADDB
GETDBACTIVE
GETDBINFO
GETDBSTATE
SETDBSTATE
SETDBSTATEITEM
GETDBSTATS
UNLOADDB
LISTFILES
SHUTDOWNSERVER

User/Group Security

Use these commands to perform user and group administration.

DISABLELOGIN
ENABLELOGIN
LOGOUTUSER
LOGOUTALLUSERS
CREATEUSER
DELETEUSER
RENAMEUSER
LISTUSERS
GETUSERINFO
SETPASSWORD
CREATEGROUP
DELETEGROUP
LISTGROUPS
ADDUSER
REMOVEUSER
LISTGROUPUSERS

Security Filters and Locks

Use these commands to list, copy and rename security filters, and to view and remove database locks.

LISTFILTERS
COPYFILTER
RENAMEFILTER
LISTLOCKS
REMOVELOCKS

Database Objects

Use these commands to list database objects and their lock statuses, copy and rename database objects, and to view and remove URLs, cell notes, or partitions linked to the database.

LISTOBJECTS
COPYOBJECT
RENAMEOBJECT
UNLOCKOBJECT
LISTLINKEDOBJECTS
PURGELINKEDOBJECTS

Outline/Attribute Information

Use these commands to view member and attribute information, and view current attribute naming specifications for the database.

GETMBRINFO
GETMEMBERS
GETATTRINFO
GETATTRIBUTESPECS

Use these commands to build one or more dimensions from data files or SQL sources. You can build multiple dimensions incrementally, with or without automatic restructuring after the dimension build is complete.

BUILDDIM
INCBUILDDIM
BEGININCBUILDDIM
ENDINCBUILDDIM

Data Loading, Clearing, and Exporting

Use these commands to load data files or individual records, to clear all data from the database, or to export and import data to and from a text file.

LOADDATA
UPDATE
UPDATEFILE
RESETDB
EXPORT
IMPORT

Calculating

Use these commands to run calc scripts, execute one or more calc strings, run or change the default calculation, and view information about calc strings associated with members.

CALC
CALCDEFAULT
CALCLINE
GETDEFAULTCALC
GETMBRCALC
RUNCALC
SETDEFAULTCALC
SETDEFAULTCALCFILE

Reporting

Use these commands to run report scripts and execute one or more report strings.

RUNREPT
REPORT
REPORTLINE

Partitioning

Use these commands to:

Produce an ASCII text file of the distributed database's partition mapping tables.
Replicate all data cells, or only updated data cells, in a replicated partition.
- Use "GET" commands to replicate cells from source to target, when you are in the target server.
- Use "PUT" commands to replicate cells from source to target, when you are in the source server.

PRINTPARTITIONDEFFILE
GETALLREPLCELLS
PUTALLREPLCELLS
GETUPDATEDREPLCELLS
PUTUPDATEDREPLCELLS

Outline Synchronization

Use these commands to keep the target database outline synchronized with changes made to the source database outline. These commands utilize an outline change file (.CHG) to track changes made on the source outline, apply those changes to the target outline, and synchronize time stamps in the partition definition files.

GETPARTITIONOTLCHANGES
APPLYOTLCHANGEFILE
PURGEOTLCHANGEFILE
RESETOTLCHANGETIME