SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-2
approximate numeric type
approximate numeric 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 type
.
attribute. A name and value that describe a characteristic of an object, column, data type,
DEFINE, index, file, SQLCI session, or table. See also character set
, collation, column
attribute, data type, data-type attribute, DEFINE attribute, file attribute, heading, and
session attribute.
audit trail. A series of audit files containing audit records of TMF transactions that made
changes to audited tables and disk files.
audited table. A table flagged for auditing by the Transaction Management Facility (TMF).
The TMF subsystem monitors all transactions against an audited table in preparation for
possible transaction backout, volume recovery, or file recovery.
authority. Permission granted to a user or a group of users to read, write, execute, or purge
an SQL object or a file. See also security string
.
automatic SQL recompilation. The SQL recompilation in memory of a program or SQL
statement invoked by the SQL executor at run time. Automatic recompilation occurs, for
example, when a program file is marked as invalid or when an SQL statement refers to
an SQL object or a DEFINE that has changed since the program’s last explicit SQL
compilation (if the program was not compiled with the NORECOMPILE option). In
some cases, the similarity check can bypass automatic SQL recompilation. See also
explicit SQL compilation
and similarity check.
base table. A table that has physical existence: that is, a table stored in a file. Contrast with
view
. See also file.
base-table predicate. A predicate evaluated by the disk process or the file system on rows in
the base table.
Binder product. A Compaq software product that reads, links, and produces object files.
break column. A report column that defines a break group.
break footing. One or more lines of text that appear at the end of a set of lines in the same
break group.
break group. In a report, a group of detail lines that have equal values in a specified column
of the select list or in a named detail column.
break title. Text that precedes the first line of a break group in a report.