SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-6
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 the following statements to manage mappings between logical and physical
names for SQL/MP objects:
Stored Procedure Statements
Use these statements to register and invoke stored procedures in Java (SPJs):
SET CATALOG Statement on
page 2-291
Sets the default ANSI catalog for unqualified schema
names for the current session.
SET MPLOC Statement
on
page 2-293
Sets the default operating system volume and
subvolume for SQL/MP physical object names for the
current session.
SET NAMETYPE Statement
on
page 2-294
Sets the default NAMETYPE attribute value to ANSI
or NSK for the current session.
SET SCHEMA Statement
on
page 2-295
Sets the default ANSI schema for unqualified object
names for the current session.
ALTER SQLMP ALIAS Statement
on
page 2-10
Maps an existing alias to a different SQL/MP table.
CREATE SQLMP ALIAS Statement
on page 2-92
Creates mappings from logical names to physical
names for SQL/MP database objects.
DROP SQLMP ALIAS Statement
on
page 2-170
Drops mappings from logical names to physical
names for SQL/MP database objects.
CALL Statement
on page 2-46 Initiates the execution of a stored procedure in Java
(SPJ) in NonStop SQL/MX.
CREATE PROCEDURE Statement
on page 2-80
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
DROP PROCEDURE Statement
on
page 2-165
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
GRANT EXECUTE Statement
on
page 2-211
Grants access privileges for a procedure to specified
users.
REVOKE EXECUTE Statement
on
page 2-248
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 onwards.