SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-27
plan fragment
plan fragment. A portion of a query execution plan that executes within a single process
such as DAM, ESP, or master executor.
policy file. A file that instructs the Java security manager to allow certain restricted
operations.
positioned iterator. A type of iterator where the data types of columns in the iterator
declaration correspond in order to the data types of columns in the result table.
Contrast with named iterator. See also iterator.
precision. A positive integer that represents the number of significant digits, the maximum
number of digits in the evaluation of an arithmetic expression. Contrast with scale.
predicate. A Boolean expression that determines an answer to a question about a value or
group of values. A predicate returns true, false, or, if the question cannot be answered,
unknown. You use predicates within search conditions to choose rows from tables or
views.
preprocessor. See SQL preprocessor.
primary key. A column or set of columns that define the uniqueness constraint for a table.
The columns cannot contain nulls, and there is only one primary key constraint on a
table. See also clustering key.
primary partition. The partition of a partitioned table or index that contains the lowest set of
key values if the collating sequence is ascending, or the highest set of key values if the
collating sequence is descending.
procedure. A routine that does not return a value. Contrast with function. See also routine.
process. An executing object program, including code and data spaces.
process name. An operating system name that can be assigned to a process when the
process is created. A process name uniquely identifies a process or process pair on a
node.
processed module name. In the context of module management, the module name that
results after it has been qualified with the default catalog and schema (if none was
given in any MODULE directive), after it has been synthesized based on a timestamp
(if no MODULE directive was given). In product versions prior to SQL/MX 1.8, the
delimited identifier characters can be transformed. In SQL/MX 1.8, the delimited
identifier characters, except for the beginning, ending, and any embedded quotes, are
preserved as is.
profile. A .ser file that contains serialized Java object code, including SQLJ clauses and
host variable attributes. The SQLJ translator generates one profile for each connection
context in the SQLJ source file (.sqlj file).