HP Integrity NonStop J-Series - Manual (Page 73)

6. Select an SQL/MP alias.
In the right pane, the following tabs related to the SQL/MX alias appear:
•
Attributes
•
DDL
Figure 25 (page 73) shows the properties of an SQL/MP alias.
Figure 25 SQL/MP alias properties
Viewing attributes of the SQL/MP alias
To view the attributes of a SQL/MP alias:
1.
In the navigation tree, select the SQL/MP alias.
2. In the right pane, click Attributes.
The following details related to attributes appear:
•
Name: — The name of the SQL/MP alias.
•
Metadata UID: — A unique ID number of the SQL/MP alias.
•
SQL/MP Table: — The Guardian location of the SQL/MP table associated with the alias.
Viewing DDL information of a SQL/MP alias
To view DDL information related to the SQL/MP alias:
1.
In the navigation tree, select the SQL/MP alias.
2. In the right pane, click DDL.
The DDL tab displays a statement that you can use to create the SQL/MP Alias.
Viewing sequence generators and their properties
To view the sequence generators and their properties:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2. In the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. In the navigation tree, expand the contents of the system.
The list of catalogs appears.
4. Expand the contents of a catalog.
The list of schemas appears.
Viewing sequence generators and their properties 73