SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-36
SQL/MX optimizer
SQL/MX optimizer. See optimizer.
SQL/MX software version (MXV). The version of the SQL/MX system software that is
installed on a node.
SQL/MX UDR server. A layer of software between the SQL/MX executor and a Java Virtual
Machine (JVM) that provides support for a stored procedure in Java (SPJ) in SQL/MX.
Also refers to a running instance of the MXUDR program in which SPJ methods are
executed by an embedded Java Virtual Machine (JVM).
statement atomicity. The ability to undo the effects of an insert/update/delete (IUD)
operation, when an error occurs during the operation, without having to abort the entire
transaction.
statement pinning. The ability of SQL/MX to hold entries in the query plan cache that you
want to reuse.
static SQL. A programming technique that uses SQL statements that are constructed and
compiled before the program begins executing. Contrast with dynamic SQL.
static SQL compilation. See explicit SQL compilation.
storage key. See clustering key.
stored procedure. A procedure registered with SQL/MX and invoked by SQL/MX during
execution of a CALL statement. A stored procedure may pass values back to its caller
by assigning those values to parameters having the OUT parameter mode or INOUT
parameter mode. See also stored procedure in Java (SPJ).
stored procedure in Java (SPJ). A stored procedure whose body is a static Java method.
The body is known as an SPJ method.
stream access. Allows applications to access tables as continuous data streams. The
stream access mode first does a regular scan of the table. Then, if all available rows
have been retrieved, the stream access mode causes fetch operations to wait instead
of returning the end-of-data condition.
string literal. Data composed of characters. A string literal has character data type.
structured query language (SQL). See SQL.
subquery. A query expression enclosed in parentheses; its syntactic form is specified in the
syntax of a SELECT statement. A subquery can specify the comparison values for a
predicate in a search condition or can be used as a table reference. A scalar subquery
returns a single value, a row subquery returns a single row, and a table subquery
returns multiple rows.
subscribe. To request access to entries in a queue or channel by using a SELECT
statement specifying stream access.