SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-9
double-byte character set
double-byte character set. A character set consisting of characters that require two bytes
each for storage.
double-byte column. A column that has an associated double-byte character set.
DP2. See disk process
.
DSL (Data Status Language). The set of data status statements within the SQL language.
DSL statement. A statement that retrieves status information about the version of a database.
Contrast with DCL statement
, DDL statement, and DML statement.
dynamic SQL. A programming technique that enables an application program to construct,
compile, and execute an SQL statement that is unknown until the program is executing.
Dynamic SQL supports interactive statements entered at a terminal.
D-series node. A node running a D-series release version of the operating system.
EDIT file. A Guardian disk file whose file code is 101. An EDIT file can be created, read,
and modified by the PS Text Edit and EDIT text editors on a NonStop system.
embedded SQL. SQL statements in a host language program.
empty section. The uncompiled portion of an SQL statement in a program file that is missing
an execution plan. The SQL compiler generates an empty section if an SQL statement
references a nonexistent DEFINE or SQL object. The SQL executor must automatically
recompile the statement at run time to generate an execution plan.
Enscribe. A Compaq database record management system used on NonStop systems.
Enscribe DDL. See DDL product
.
entry-sequenced file. A file in which each new record is stored at the end of the file in
chronological sequence. Records can be updated but not deleted. Contrast with key-
sequenced file and relative file. See also entry-sequenced table.
entry-sequenced table. A table stored in an entry-sequenced file and whose primary key is a
system-generated record address. Columns cannot be added to an entry-sequenced table,
rows can be updated but not deleted, and variable-length character values cannot be
lengthened or shortened. Contrast with key-sequenced table
and relative table.
ESP (executor server process). A process that executes a portion of a parallel execution
plan.
exact numeric type. A numeric data type that has both precision and scale. The precision is a
positive integer that represents the number of significant decimal digits. The scale is a
nonnegative integer. The SQL exact numeric types are DECIMAL, INTEGER,
LARGEINT, NUMERIC, and SMALLINT. Contrast with approximate numeric type
.
exception condition. An abnormal or unexpected result of a programmatic operation.