Manualshelf

SQL/MP Glossary

ManualsBrandsHP ManualsServerHP NonStop G-Series
11121314151617181920
Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-7
data-type attribute
data-type attribute. A format, character set, collation, or coercibility attribute associated
with a data type for a column, expression, function, host variable, literal, or parameter.
datetime qualifier. See range of DATETIME fields
.
date-time data type. The DATETIME, DATE, TIME, or TIMESTAMP data type. DATE,
TIME, and TIMESTAMP are predefined subsets of DATETIME. Date-time data
consists of formatted values for one or more of the following fields: YEAR, MONTH,
DAY, HOUR, MINUTE, SECOND, and FRACTION.
date-time literal. A literal that has a DATETIME, DATE, TIME, or TIMESTAMP data type.
DBA (database administrator). The person who defines or manages a database or controls
access to a database.
DCL (Data Control Language). The set of data control statements within the SQL language.
DCL statement. A statement used to control process resources such as locks and cursors.
Contrast with DDL statement
, DML statement, and DSL statement.
DDL (Data Definition Language). The set of data definition statements within the SQL
language. Contrast with DDL product
.
DDL product. A Compaq product for defining Enscribe files and data structures.
DDL statement. A statement used to define, delete, or modify the SQL definition of an
object or catalog or to change the authorization to use the object or catalog. Contrast
with DCL statement
, DML statement, and DSL statement.
deadlock. A block to data access caused by processes contending for the same data. For
example, deadlock occurs when process A has locked one row and is waiting for another
row already locked by process B, and process B is waiting for the row already locked by
process A.
DEFINE. A named set of attribute-value pairs, which associate attribute names with values.
For example, a DEFINE name can be used as a logical name in an SQL statement to
identify a catalog or table, and the value of the DEFINE attribute SUBVOL or FILE is
the actual operating system name of the catalog or table.
DEFINE attribute. An attribute that identifies a class of DEFINEs (for example, CLASS
MAP or CLASS CATALOG) or a particular object (for example, FILE file-name or
SUBVOL subvolume-name). A DEFINE attribute name is always associated with a
value as an attribute-value pair in a DEFINE. See also DEFINE
.