SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-5
Object Naming Statements
Object Naming Statements
Use these statements to set the value of the NAMETYPE attribute, which determines
whether the object naming is ANSI or NSK for the current session, and to specify
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-230
Sets the default ANSI catalog for unqualified schema
names for the current session.
SET MPLOC Statement
on
page 2-232
Sets the default operating system volume and
subvolume for SQL/MP physical object names for the
current session.
SET NAMETYPE Statement
on
page 2-233
Sets the default NAMETYPE attribute value to ANSI
or NSK for the current session.
SET SCHEMA Statement
on
page 2-234
Sets the default ANSI schema for unqualified object
names for the current session.
ALTER SQLMP ALIAS Statement
on
page 2-8
Alters mappings from logical names to physical
names for SQL/MP database objects.
CREATE SQLMP ALIAS Statement
on page 2-73
Creates mappings from logical names to physical
names for SQL/MP database objects.
DROP SQLMP ALIAS Statement
on
page 2-130
Drops a mapping from a logical name to a Guardian
physical location.
CALL Statement
on page 2-27 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-125
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
GRANT EXECUTE Statement
on
page 2-163
Grants access privileges for a procedure to specified
users.
REVOKE EXECUTE Statement
on
page 2-191
Revokes access privileges for a procedure to
specified users.
Note. The Result Set Support for Stored Procedures in Java is available only on systems
running J06.05 and later J-series RVUs and H06.16 and later H-series RVUs. This feature is
supported by SQL/MX 2.3.2.