SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-8
DEFINE name
DEFINE name. An identifier that can be used in place of an actual subvolume or file name
in an SQL statement to identify a catalog, table, view, index, collation, file, or partition;
the identifier starts with an equal sign. NonStop SQL/MP replaces the logical DEFINE
name with the actual name when compiling or recompiling the statement. See also
DEFINE
.
definitional integrity. The condition of a database when its file labels and catalog tables
contain consistent definitions of objects. Contrast with data integrity
.
dependency. The use of an object by another object.
dependent object. An object whose definition depends on the definition of a base or
underlying object; for example, an index or protection view is dependent on a table.
detail alias. A name assigned to a print item by the NAME clause of a DETAIL command for
use when referring to the item in other report commands.
detail column. An item specified in a DETAIL command.
detail line. One or more report lines printed in the format specified in a DETAIL command.
The data for each detail line corresponds to one row of data retrieved by a SELECT
statement.
dictionary. See data dictionary
.
directive. A statement that gives instructions to a compiler.
discontiguous key. A key formed from two or more columns of a table in which the key
columns are not physically adjacent or are not in the same physical order as in the key.
disk directory. A directory that contains the file labels for each SQL table, view, index, and
collation on a disk volume and the location of each object on the disk.
disk process. The portion of the operating system software that performs read, write, and
lock operations on disk volumes and creates TMF audit records. The DP2 disk process
is a NonStop SQL/MP software component. Contrast with file system
.
distributed database. A database whose objects reside on more than one node in a network
and whose objects can be accessed from any node in the network.
distributed dictionary. A data dictionary whose definitions reside on more than one node in
a network; the dictionary for a distributed database.
DML (Data Manipulation Language). The set of data manipulation statements within the
SQL language.
DML statement. A statement used to select, update, insert, or delete rows in one or more
tables. Contrast with DCL statement
, DDL statement, and DSL statement.
double-byte character. A character that requires two bytes for storage.