SQL/MX Glossary

Glossary

HP NonStop SQL/MX Glossary—523732-002

Glossary-22

MXSQLCO

MXSQLCO. The SQL COBOL preprocessor. See SQL preprocessor.

MXUDR. The SQL/MX UDR server. See also SQL/MX UDR server.

MXV. See SQL/MX software version (MXV).

name resolution. The process of resolving names in a statement by mapping logical

names to their physical names and expanding partially qualified object and schema

names by using the current default values.

namespace. A logical naming scheme for grouping related types. SQL/MX supports the

following namespaces for externally accessible objects: table, index, constraint, trigger,

and module.

named iterator. A type of iterator where the names for each iterator column are specified in

the iterator declaration and must match the names of the corresponding columns in the

result table. Contrast with positioned iterator. See also iterator.

national character set. A special character set defined during the SYSGEN of an operating

system or by the default attribute NATIONAL_CHARSET. This character set governs

the interpretation of the character string literal with the N prefix and the NCHAR

keyword used in a CAST operation. See also character set.

natural join. A type of join that joins rows only where the values of all columns that have the

same name in both tables match. Also called natural inner join.

natural left join. A type of join that joins rows where the values of all columns that have the

same name in both tables match, plus rows from the left table that do not meet this

condition.

natural right join. A type of join that joins rows where the values of all columns that have

the same name in both tables match, plus rows from the right table that do not meet

this condition.

nested join. A join method that compares each row from the outer table with each row from

the inner table to find a match between the specified join columns from the two tables.

node. A uniquely identified computer connected to one or more other computer systems in

a network.

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.

nonrepeatable reads. Reads of committed values for the same item at different times or of

items that no longer exist. Compare with dirty reads and phantom reads.