SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-30
string literal
string literal. Data composed of single-byte or double-byte characters. A string literal has the
data type CHARACTER or NATIONAL CHARACTER and can have an associated
character set.
Structured Query Language. See SQL (Structured Query Language)
.
style option. One of a set of options that control the default elements of a report. Style
options include specification of date and time formats, the underline character, the
decimal character, and headings. A style option can apply to more than one report
developed in a session.
subquery. A special form of the SELECT statement that selects only for purposes of
comparison. A subquery can be specified only as a predicate in a search condition. See
also predicate
and search condition.
superuser. In the Open System Services (OSS) environment, the administrator having the
Guardian super ID and therefore having appropriate privileges.
swap file. A disk file used for copying data between physical memory and disk storage.
SYSKEY column. A system-defined primary key or the last column in a primary key that
starts with a clustering key. See also clustering key
and system-defined primary key.
system catalog. The catalog that includes the CATALOGS table, which describes all catalogs
on the node. By default, the system catalog is located on a subvolume named
$SYSTEM.SQL. The system catalog can be located on another volume and subvolume,
but the CATALOGS table is always on a subvolume named SQL. See also CATALOGS
table.
system catalog format version. A version that indicates the physical structure of the system
catalog and the oldest version of NonStop SQL/MP software that can read and write to
the catalog. The string is stored in the CATALOGFORMAT column of the VERSIONS
catalog table. Contrast with system catalog version
.
system catalog version. A version that indicates the newest version of SQL objects that can
be registered in the system catalog. Contrast with system catalog format version
. See
also catalog version
and object version.
system default national character set. The character set associated with the NATIONAL
CHARACTER data type and the national character string literal. The national character
set is Kanji by default, but can be changed to another multibyte character set at system
generation time
system name. See node name
.
system number. See node number
.
system version. Seesoftware version
.