SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-21
packed record format
packed record format. A layout of all values in a row in the form of a record in which all
blank padding at the end of the values of a variable-length character data type and all
blank padding preceding word-aligned values have been removed. Contrast with
exploded record format
.
page footing. One or more lines of text that appear at the end of each report page.
page title. A title that appears at the top of each report page.
PAID (process accessor ID). The user ID associated with a process. The process accessor ID
is the user ID of the user who started the process unless the PROGID attribute is set for
a program file. PROGID sets the process accessor ID to the user ID of the owner of the
program file.
parallel sort. A sorting process that shortens the elapsed time for sorting large files by
distributing the workload to multiple processors, by using scratch files on multiple disks.
parameter. A name specified in a statement or prepared command for which you substitute a
value when executing the statement or prepared command. A parameter has a data type
and can have an associated character set or collation.
partition. The portion of a partitioned table or index that resides on a particular disk volume;
a nonpartitioned table (single-partition table).
partition array value . The value that indicates the size of the partition array and if it is
Format 1 or Format 2 enabled. This controls whether partitions are limited to Format 1
or may be larger Format 2. It is set when a table is created or altered.
partition lock. A lock held by a process on all the rows in a partition of a table or in a
nonpartitioned table. Contrast with generic lock
, row lock, and table lock.
partitioned object. A table or index that resides on more than one disk volume, possibly on
more than one node.
Pathmaker application development tool. A Compaq product that can be used to develop
online transaction processing applications managed by Pathway.
pathname. In the Open System Services (OSS) environment, a string of characters that
uniquely identifies a file within its file system. A pathname can be either relative or
absolute.
Pathway. A Compaq product that can be used to configure and manage online transaction
processing applications.
PCV. See program catalog version (PCV)
.
PFS. See process file segment (PFS)
.
PFV. See program format version (PFV)
.