Databases Reference
In-Depth Information
Syntax:
create application 'Application_Name' type 'Mode' as 'Application_
Name ' comment 'Comment-String';
'Application_Name'
: Name of the new application should be upto 8 characters
long as with all Essbase database objects.
type
: Indicates whether this application is to be Unicode or not with the default
being is non-Unicode mode. Unicode is a system of assigning a unique number to
each character regardless of the language or platform. When a database is created
using the Unicode convention, users from all parts of the globe, using all different
character sets can use your Essbase system without worry of data corruption.
As 'Application_name
'
[optional]
: Name of the existing application which
will be copied to the new application.
comment 'Comment-String' [optional
: This is a comment which is given to
the application and can be viewed in the application properties screen.
Example 1
: In the following example, we are creating a new application. Since we
did not mention the Unicode mode, by default, it will be created as a non-Unicode
application.
Create application ESSCARNW comment 'New Esscar Application';
Example 2
: In the next example, we are creating a new application which is same
as the existing application and will be for the purpose of an application backup.
Create application ESSCARBK as ESSCAR comment 'Back up of Esscar
Application';
Now that you have seen how we can create an application using a MaxL statement,
let us see how we can use the alter application statement in MaxL.
Altering the application
With the
alter
statement, you can set the properties for an application, add, modify,
or drop a substitution variable, load or unload an application, enable or disable
application start up commands, add an application comment, or clear an application
log file.
