SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—544536-007
9-14
Adding SQL/MP Aliases
Schema names that being with DEFINITION_SCHEMA_VERSION_ are reserved (in
all catalogs) for system metadata. You cannot create schemas with these names in
user catalogs.
For more information, see the SQL/MX Reference Manual.
Steps for Adding a Schema
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine a name for the schema you wish to add.
3. Query the system metadata to ensure the new schema name is unique among
existing schema names in the catalog.
4. Enter the CREATE SCHEMA statement,.
For more information and examples of creating schemas, see Creating Schemas on
page 7-9.
Adding SQL/MP Aliases
Use the CREATE SQLMP ALIAS statement to add an SQL/MP alias to your SQL/MX
database.
For more information, see the SQL/MX Reference Manual.
Steps for Adding an SQL/MP Alias
1. Start an MXCI session. Enter a LOG command to initiate a log file for statements
and commands entered in this session. Keep the log for your records.
2. Determine a name for the SQL/MP alias you wish to add.
3. Query the system metadata to ensure the new SQL/MP alias name is unique
among existing table, view, SQL/MP alias, and SPJ names in the schema.
4. Enter the CREATE SQLMP ALIAS statement.
For more information and examples of creating SQL/MP aliases, see the SQL/MX
Reference Manual.
Adding Stored Procedures in Java (SPJs)
Use the CREATE PROCEDURE statement to add an SPJ to your SQL/MX database.
For information and examples, see the SQL/MX Guide to Stored Procedures in Java.
Adding SQL/MX Tables
Use the CREATE TABLE statement to add a table to your SQL/MX database.