SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-8
data source
data source. The data a user wants to access and the associated operating system,
database management system (dbms), and network platform used to access the
dbms. To manage ODBC client access to SQL/MX data, you can add, configure, and
delete ODBC/MX data sources on both the HP NonStop system and the client
computer.
data type. A set of valid values with an associated data format. All values in a column must
conform to the format of the column’s data type. Expressions, functions, host variables,
literals, and parameters also have data types. All values passed as parameters to a
user-defined routine must conform to the format of the parameter's data type. SQL/MX
provides data types for character strings of fixed and varying length, binary and
decimal numbers, datetime values, and intervals. See also approximate numeric data
type, data type attribute, datetime data type, exact numeric data type, and INTERVAL
data type.
data type attribute. A format associated with a data type for a column, expression,
function, host variable, literal, or parameter.
database. A collection of interrelated data with a given structure for storing and providing,
on demand, data for multiple users. See also SQL/MX executor.
database administrator. See DBA.
database object. See SQL object.
datetime data type. The DATE, TIME, or TIMESTAMP data type. Datetime data consists of
formatted values for one or more of these fields: YEAR, MONTH, DAY, HOUR,
MINUTE, SECOND.
datetime expression. An SQL value expression built from operands such as datetime or
interval literals, column names with datetime or interval values, datetime or interval
value functions, host variables or any set functions, scalar subqueries, CASE
expressions, or CAST specifications that return datetime or interval values.
datetime literal. A literal that has a DATE, TIME, or TIMESTAMP data type. SQL/MX
supports a DATETIME literal for insertion into DATETIME columns in an SQL/MX
table.
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 and DML statement.
DDL. Data Definition Language. The set of data definition statements within the SQL
language.