SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-32
TNS
error occurs while a transaction is in progress, the TMF subsystem backs out whatever
partial changes were made to the database, leaving it in a consistent state.
TNS. See Tandem NonStop Series (TNS)
.
TNS/R. See Tandem NonStop Series/RISC (TNS/R)
.
transaction. A series of changes that transform a database from one consistent state to
another. See also TMF transaction
.
transaction backout. A TMF mechanism that returns any rows changed by an incomplete
transaction to their state before the start of the transaction.
Transaction Management Facility. See TMF (Transaction Management Facility)
.
type checking. To determine whether data types are compatible.
unaudited table. See nonaudited table
.
unique index. An index in which the combined values of the columns that make up the index
uniquely identify the rows in the underlying base table.
UNKNOWN character set. The default character set for NonStop SQL/MP.
NonStop SQL/MP treats UNKNOWN data as 8-bit data.
usage entry. An entry in the USAGES catalog table that indicates the dependency between
an SQL object and an SQL program or between two SQL objects.
user-defined primary key. The column or columns specified in the PRIMARY KEY clause
of a CREATE TABLE statement to uniquely identify the rows in a key-sequenced table.
Together the columns form a unique key that determines the order in which the rows of
the table are stored. Contrast with clustering key
, index, and system-defined primary
key. See also primary key.
user-defined TMF transaction. A TMF transaction defined by an application either in a
program unit or in a requester on whose behalf the program unit performs database
operations. See also TMF transaction
.
utility. A software tool that can be used to perform a specialized task such as loading data
into a database, analyzing catalogs for consistency, or examining access strategies.
valid program. A host-language program that contains semantically correct execution plans,
is operable, and is marked as SQL valid in the PROGRAMS table in the catalog and in
its file label. Contrast with invalid program
.
version number. A number that indicates compatibility with different versions of
NonStop SQL/MP software. See also catalog format version
, catalog version, HOSV
(host object SQL version), object version, program catalog version (PCV), program
format version (PFV), software version, system catalog format version, and system
catalog version.