Databases Reference
In-Depth Information
Code Sample:
alter database 'ESSCAR'.'ESSCAR' rename to 'ESSCARN';
These are some of the commands that you can perform using the ALTER database.
Display database
With MaxL you can display all of the pertinent information about a database in one
easy command.
Syntax:
display database <all | Db-Name | on application App-name>;
Code Sample:
display database;
display database all;
display database 'ESSCAR'.'ESSCAR';
Drop database
This command is used to delete Essbase databases and if a database has some of
its objects locked, then also use the FORCE parameter to unlock those objects.
Syntax:
drop database <Db-Name>;
Code Sample:
drop database 'ESSCAR'.'ESSNEW';
drop database 'ESSCAR'.'ESSNEW' force;
Working with data in MaxL
With MaxL statements you can also
import
data into an Essbase database or export
data from the Essbase database to a text file. These two statements are powerful
statements and are very widely used.
The import statement not only imports data into the Essbase cube, it is also used t
o update dimensions in the outline.
