SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-12
fileset
fileset. A specification of one or more files used in SQLCI utility commands, optionally
using wild-card characters to define name patterns. (Note that this is not the same as the
Open System Services (OSS) definition of fileset.)
first key. The primary-key value or clustering-key value allowed for the first row in a
partition. Whether the value in each key column is high or low depends on the ascending
or descending collating sequence defined for the column. The value is the lowest in the
partition for ascending columns and the highest for descending columns.
format. Partitions may be either format 1, which will limit its size to two gigabytes, or format
2, which will limit its size to one terabyte or the limit of a single disk volume, whichever
is smaller. The format of a partition is limited by whether the table or index is Format 2
enabled.
format enabling. In order to take advantage of the larger size partitions available with
Format 2 files, a table or index must be format 2 enabled, either when it is created or by
performing ALTER TABLE. You must either specify PARTITION ARRAY as
FORMAT2ENABLED, or specify an individual partition as FORMAT 2. Format
enabling only applies to key-sequenced files and does not apply to relative or entry-
sequenced files.
Format 1 Enabled Index, Format 1 Enabled Table. An index or table that allows only
Format 1 partitions. Its partition array value is STANDARD or EXTENDED.
Format 1 Partition. A partition of a table or index whose partition format is 1. Its size is
limited to two gigabytes.
Format 2 Enabled Index, Format 2 Enabled Table. An index or table that allows a
combination of Format 2 or Format 1 partitions. Its partition array value is
FORMAT2ENABLED.
Format 2 Partition. A partition of a table or index whose partition format is 2. Its size is
limited to one terabyte or the limits of a single disk volume, whichever is smaller.
FS2. See file system
.
generic lock. A lock held by a process on a contiguous subset of the rows in a table. Contrast
with partition lock
, row lock, and table lock.
grouped select. A query that generates a single row in the result table by processing a set of
rows from the table produced by the FROM clause. The grouping is determined by a
GROUP BY clause, an aggregate function in the select list, or a grouped view in the
FROM clause. The SELECT operation can result in one group (if no GROUP BY clause
is specified) or a set of groups.
grouped view. A view defined with a query that contains a GROUP BY or HAVING clause
that is not a subquery, contains an aggregate function in the select list, or refers to
another grouped view in the FROM clause.
grouping column. A column specified in a GROUP BY clause.