SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-18
NATIONAL CHARACTER data type
NATIONAL CHARACTER data type. See NCHAR (NATIONAL CHARACTER data
type).
national character string literal. A literal that has the NATIONAL CHARACTER data
type.
NCHAR (NATIONAL CHARACTER data type). A data type whose values are composed
of the characters in the system default national character set.
nested join. A join method that retrieves rows from the outer table, compares them with rows
in the inner table, retrieves rows from the inner table that satisfy the comparison, and
concatenates the inner table rows with corresponding rows from the outer tables.
network. A group of interconnected computer systems and the hardware and software used to
connect them. In NonStop SQL/MP manuals, network means two or more NonStop
systems that can communicate with each other, transfer data, and share files and other
resources. A NonStop system in a network of NonStop systems is called a node.
newer version. A version that has a higher version number than another version.
node. A system or device that follows the protocols of a specific network and that other
systems or devices in that network can address. In NonStop SQL/MP manuals, node
means a NonStop system that is or might be in a network of NonStop systems. See also
network
.
node autonomy. See local autonomy
.
node name. The portion of a file name that identifies the node (NonStop system) on which
the file can be accessed. The node name starts with a backslash (\).
node number. The internal identifier for the node (NonStop system) on which file access
occurs.
nonaudited table. A table that is not flagged for auditing by the Transaction Management
Facility (TMF) and, therefore, is not protected from node failure by TMF volume
recovery or from media failure by TMF file recovery.
noncorrelated subquery. A subquery that does not reference or depend on the result of the
outer query. A noncorrelated subquery can be evaluated once and the result used
repeatedly for the outer query. Contrast with correlated subquery
.
NonStop SQL/MP. See NSSQL/MP (NonStop SQL/MP)
.
NonStop SQL/MP catalog manager. See catalog manager
.
NonStop SQL/MP component. Any of the following, which make up the NonStop SQL/MP
software: catalog manager (SQLCAT), executor (SQLEXE), SQL compiler
(SQLCOMP), SQL preprocessor (SQLCOBOL), SQL compiler interface (SCI), SQL
utilities (SQLUTIL), SQL conversational interface (SQLCI), SQLCI2 program,
BACKUP utility, RESTORE utility, FastSort, FS2 file system, and DP2 disk process.