Altering an SQL/MP alias
Procedure
- Log on to the NonStop SQL/MX Database Manager.
- In the navigation tree, navigate to the Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
- Expand the SQL/MP Aliases folder and select the alias name you want to alter.
-
Right-click and select
Alter SQL/MP Alias.
The Alter SQL/MP Alias dialog box appears.
-
Select the required system name in the
System drop-down.
The SQL/MP Target navigation tree is populated with volume, subvolume, and file names based on the selected system.
-
Select the required volume, subvolume, and file name in the
SQL/MP Target navigation tree.
The Location text box is populated with the path selected in the SQL/MP Target tree.
- Click OK.