SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-31
savepoint
S
savepoint. A marker that allows an application to roll back part of a transaction if a minor
error is encountered. The application must still commit or roll back the full transaction
when it is complete.
scale. A positive integer that represents the number of digits to the right of the decimal point
in the evaluation of an arithmetic expression. Contrast with precision.
schema. A named collection of SQL/MX database objects. Each SQL/MX database object
is described in only one schema, although an object can refer to objects described in
other schemas. A schema cannot contain other schemas. Each schema is described in
a catalog. The schema is the unit of ownership, all database objects in a schema are
owned by the schema owner.
search condition. A predicate or compound predicate that defines the criteria for selecting
data or for including data in a table or view.
select list. A list that specifies columns or expressions to include in the result of a query or
the columns in which to insert or update data.
self-contained application. An embedded SQL C/C++/COBOL application whose sources
have been preprocessed by preprocessors without using the -x option. The application
is self-contained because it does not need separate module definition files. Its module
definitions are in the application’s object file.
self-referencing foreign key constraint. The referential constraint where a foreign key is
referencing the primary key of the same table.
sensitive command. A SQL/MX connectivity service (MXCS) administrative command that
changes data or objects in the MXCS subsystem being administrated. Contrast with
nonsensitive command.
serializable access. An access option for any DML statement that requires that the
statement and any concurrent process (accessing the same data) execute as if the
statement and the other process had run serially rather than concurrently. This option
locks all data accessed through the DML statement and holds the locks on data in
audited tables until the end of any containing transaction. Serializable access provides
the repeatable read capability. Contrast with read uncommitted access and read
committed access.
server. A process or program that provides services to a client or a requester. A server
process is a running instance of a server program. A combination of hardware and
software designed to provide services in response to requests received from clients
across a network. See also node.
session. A particular execution of MXCI from the time MXCI is invoked to the time it is
terminated.