SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-66
Stored Procedures in Java
Stored Procedures in Java
This attribute specifies the Java Virtual Machine (JVM) startup options for the Java
environment of a stored procedure in Java (SPJ):
For more information on the supported Java options, see the NonStop Server for Java
Tools Reference Pages. For more information on how to use the
UDR_JAVA_OPTIONS default attribute, see the SQL/MX Guide to Stored Procedures
in Java.
Stream Access
These attributes enable NonStop SQL/MX to implement the queuing and
publish/subscribe services:
Attribute Setting
UDR_JAVA_OPTIONS Set the attribute value to one or more Java options within single
quotes (for example, 'java-option1 java-option2'). Each
Java option can be any Java option supported by the HP NonStop
Server for Java. The Java options must conform to Java syntax,
contain no embedded white space, and have a single space
separating each option. If the same option is specified more than
once, the JVM allows the last occurrence in the string to take
precedence. CALL statements compiled with this setting are
serviced in an SPJ environment that uses the specified JVM
startup options.
Set to OFF to specify no application-specific JVM startup options in
the SPJ environment. CALL statements compiled with this setting
are serviced in an SPJ environment that does not use
application-specific JVM startup options.
Set to ANYTHING to enable NonStop SQL/MX to chose the JVM
startup options for an SPJ environment. NonStop SQL/MX does
not guarantee the types of JVM startup options that are used in a
particular SPJ environment. CALL statements compiled with this
setting are serviced in an SPJ environment chosen by NonStop
SQL/MX.
The default is OFF.
Attribute Setting
MATERIALIZE Controls whether inner tables (the non-streamed tables) of join
operations between streams and base tables are materialized. Set to
ON, OFF, or SYSTEM to direct the SQL compiler to materialize inner
tables for join operations (ON), not materialize inner tables (OFF), or
allow the system to determine whether to materialize inner tables
(SYSTEM).
If you want changes to the inner table that are made while the stream
is active to be visible in the join, set this value to OFF. The default is
SYSTEM.