Create Database (Aggregate Storage)

Click here for non-aggregate storage version

Create or re-create a database for an aggregate storage application.

The syntax for creating an aggregate storage database is the same as for creating a block storage database, except that the currency database option is not supported. You must create an aggregate storage database as part of an aggregate storage application.

Optionally create the database as a copy of another database on the same system. DBS-NAME must consist of 8 or fewer characters. Avoid spaces and special characters when naming applications and databases.

Permission required: Application designer. To copy a database, designer permission on the source database is additionally required.

Syntax

Examples

create or replace database Sample.Basic comment 'This is a test.';

Creates a database called Basic within the Sample application. If a database named Basic within the Sample application already exists, it is overwritten.

create database Sample.New as Sample.Basic;

Creates a database called New within the Sample application that is a copy of the database Basic within the Sample application.

Descriptions

Use create database to create a database in the following ways:

Key Phrase Explanation
create database Create a new database. Database names are case sensitive.
create or replace database Create a database, or replace an existing database of the same name. Database names are case sensitive.
create database as Create an aggregate storage database as a copy of another aggregate storage database.

Note: You cannot copy a block storage database to an aggregate storage database. For an example of how to create an aggregate storage application and database based on a block storage application and database, see Creating an Aggregate Storage Sample Using MaxL.

comment Create a database description (optional). The description can contain up to 80 characters.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com
appname.dbname