SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-2
ANSI internal name
SQL/MX, they are given external names. ANSI external names must conform to ANSI
naming conventions. See also ANSI internal name.
ANSI internal name. A name defined when objects are stored in the metadata. ANSI SQL
objects have both external and internal names. When objects are created or altered in
SQL/MX, they are given external names. However, when the same objects are stored
in the metadata, they are stored by their internal names. ANSI internal names must
conform to the NonStop operating system naming format. See also ANSI external
name.
ANSI view. A named specification of a result table, which is a set of rows, selected or
generated from one or more base tables.
application. A computer program, such as a word processor or spreadsheet, designed to
assist in the performance of a specific task.
application programming interface (API). A set of functions or procedures that an
application uses to request and carry out lower-level services. For example, the ODBC
API consists of the ODBC functions.
approximate numeric data type. A numeric data type that is an approximation of a real
number and consists of two parts: a mantissa and an exponent. The mantissa is a
signed numeric value, and the exponent is a signed integer that specifies the
magnitude of the mantissa. The SQL approximate numeric types are FLOAT, REAL,
and DOUBLE PRECISION. Contrast with exact numeric data type.
association server. The component of the SQL/MX connectivity service (MXCS) that
receives client connection requests for database access and associates the requestor
with an MXCS server to execute the requested access. The association server also
supplies information about the current state of various MXCS servers. See MXCS and
MXCS server.
atomicity. A state in which all actions in a transaction happen or none happen. If one part of
a transaction fails, the entire transaction fails. In SQL/MX transactions, a state in which
the effects of an SQL statement happen or do not happen. When they do not happen,
an error is returned to the application and the transaction is not aborted. See also
statement atomicity
.
attribute. A name and value that describe a characteristic of an object, column, data type,
file, or MXCI session. See also column attribute, data type attribute, file attribute,
heading, and session attribute.
audited table. A table flagged for auditing by the HP Transaction Manager Facility (TMF)
product. The TMF product monitors all transactions against an audited table in
preparation for possible transaction backout or volume recovery.
authorization ID. A unique user ID in the NonStop operating system environment. Each
user authorized to log on to a node is identified by a user ID that consists of a group
and user identification.