You can generate a database based on an SQL schema. The Query Processor uses the Enterprise Database Server to manage the data so that the audit, backup, and recovery features of Enterprise Database Server are available. Generation, update, and reorganization are managed through Relational Design Center. Backup and recovery are managed through the Database Operations Center. Once the database is generated, database access is the same as for an Enterprise Database Server database that was mapped to an SQL model.
Perform the following steps to create an SQL database:
-
From the tree view, right-click the server in which you want to create the database, and click Create SQL Database.
The Create SQL Database dialog box appears.
-
Type a name in the Database Title box.
The database title can be a fully qualified name containing a usercode, database name, and pack family, for example, (USERCODE)DATABASENAME ON PACK. You must provide at least a database name. If you omit the usercode or pack family, they default to the usercode and pack family associated with the usercode used to log into the ClearPath MCP server.
Note: Ensure that the database title is unique. If a database with the same name already exists on the ClearPath MCP server under your default pack family, the existing database is overwritten. Relational Design Center checks for the existence of a database control file under your default pack family. If a control file is not found, the SQL database is created with the given title. If the database control file exists for the given SQL database title, Relational Design Center returns a warning message. -
Click Browse.
The Open dialog box appears.
-
Navigate to the Data Definition Language (DDL) file and select the file.
The path and file name appear in the DDL File Name box.
Note: You can also type the location and name of the DDL file in the DDL File Name box. -
Type the pack family on which the SQL database is to be created in the Pack Family box.
-
Type your log-in credentials in the Usercode and Password boxes.
The Create button is enabled.
-
Click Create.
The Open Database dialog box appears.
If the create operation is successful, the database is added to the tree view along with its properties in the properties view.
The results of the operation appear in the output view.
