SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-5
Alias Statements
default ANSI names for the catalog and schema or Guardian physical names for the
volume and subvolume:
Alias Statements
Use these statements to insert into and delete from the OBJECTS Table:
Stored Procedure Statements
Use these statements to register and invoke stored procedures in Java (SPJs):
SET CATALOG Statement on
page 2-212
Sets the default ANSI catalog for unqualified schema
names for the current session.
SET MPLOC Statement
on
page 2-214
Sets the default operating system volume and
subvolume for SQL/MP physical object names for the
current session.
SET NAMETYPE Statement
on
page 2-215
Sets the default NAMETYPE attribute value to ANSI
or NSK for the current session.
SET SCHEMA Statement
on
page 2-216
Sets the default ANSI schema for unqualified object
names for the current session.
ALTER SQLMP ALIAS Statement
on
page 2-9
Alters mappings from logical names to physical
names for SQL/MP database objects.
CREATE SQLMP ALIAS Statement
on page 2-71
Creates mappings from logical names to physical
names for SQL/MP database objects.
DROP SQLMP ALIAS Statement
on
page 2-128
Drops a mapping from a logical name to a Guardian
physical location.
CALL Statement
on page 2-29 Initiates the execution of a stored procedure in Java
(SPJ) in NonStop SQL/MX.
CREATE PROCEDURE Statement
on page 2-61
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
DROP PROCEDURE Statement
on
page 2-122
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
GRANT EXECUTE Statement
on
page 2-145
Grants access privileges for a procedure to specified
users.
REVOKE EXECUTE Statement
on
page 2-173
Revokes access privileges for a procedure to
specified users.