SQL/MX Glossary

Glossary

HP NonStop SQL/MX Glossary—523732-002

Glossary-24

NonStop SQL/MP

NonStop SQL/MP. See SQL/MP.

NonStop SQL/MX. See SQL/MX.

NonStop SQL/MP conversational interface. See SQLCI.

NonStop SQL/MX conversational interface. See MXCI.

NonStop TMF product. See Transaction Management Facility (TMF).

normalizer. A portion of the SQL compiler that takes the semantically correct query tree

and performs certain unconditional transformations, such as constant folding, subquery

elimination, and recognizes equivalent expressions by representing equivalent groups

of values. These transformations make the query representation suitable for

optimization. The transformations are not based on cost. Produces the normalized

query tree as input to the optimizer (semantically correct query tree in canonical form).

NSM/web. A Web-based tool for managing SQL/MX connectivity services (MXCS) and

database objects.

null. A missing or unknown SQL value.

numeric data type. A data type for data composed of numbers, stored either in binary form

or as ASCII characters. Contrast with character data type.

numeric expression. An SQL value expression built from operands such as numeric

literals, column names with numeric values, numeric value functions, host variables or

any set functions, scalar subqueries, CASE expressions, or CAST specifications that

return numeric values.

numeric literal. Data composed of numbers. A numeric literal can be exact or approximate.

OBEY command file. A text file containing statements or commands you can execute by

using an OBEY command.

object. See Java object or SQL object.

object feature version (OFV). The description of features actually used by a database

object. The version can change as features are added or removed from an object

during DDL or utility operations.

object name. An object identifier that is either a three-part logical name or a four-part

physical NonStop operating system name. A logical name has the form

catalog.schema.name, where each of the three parts is an SQL identifier, and a

NonStop operating system name has the form [\node.][[$volume.]sub-

vol.]filename. See also alias mapping, catalog, and schema.