Sample XSETLINE Statements and Resulting Set Descriptions

Parameters › XSETLINE Statement › Sample XSETLINE Statements and Resulting Set Descriptions

Sample XSETLINE Statements and Resulting Set Descriptions

To Create a Three-Line Set Description:

To create a three-line set description containing the set name in line 1, the set order in line 2, and the pointers in line 3, use these parameter statements:

XSETLINE SET-NAME
XSETLINE SET-ORDER
XSETLINE POINTERS

A resulting set description looks like this:

5 DEPT-TEACHER     DEPT     39,   48 / AA    TEACHER                 94,  48 / AA
                                                DEPT-TEACHER
                                                LAST
                                                NPO

To Create Blank Fields or Blank Lines in a Set Description:

You can create blank fields or blank lines in the set description to make room in the Cross-Reference Report for handwritten information. A set description with a blank five-character field in the first line and a blank second line is specified like this:

XSETLINE SET-NAME,BLANK 5,SET-ORDER
XSETLINE

Here are two resulting set descriptions:

5 DEPT-TEACHER        DEPT      39,  48 / AA    TEACHER           94,    48 / AA
                               DEPT-TEACHER           LAST
6 IX-DEPT-NAME        SYSTEM (SR7)              DEPT              39,    48 / AA
                               IX-DEPT-NAME           ASC DEPT-NAME DF

To Combine Explicit and Implicit Placement of Sort Keys:

A set description with the first sort key on the second line and additional sort keys on the last lines is specified like this:

XSETLINE SET-NAME
XSETLINE SET-ORDER(1)
XSETLINE POINTERS,MEM-OPT,SET-MODE
XSETLINE SET-ORDER(N)

Resulting set descriptions:

5 DEPT-TEACHER     DEPT     39,   48 / AA    TEACHER                 94,  48 / AA
                                                 DEPT-TEACHER
                                                 LAST
                                                 NPO OM

6 IX-DEPT-NAME     SYSTEM (SR7)              DEPT                    39,  48 / AA
                                                 IX-DEPT-NAME
                                                 ASC DEPT-NAME DF
                                                 N  MA MODE = INDEX

7 IX-STUD-LNAME    SYSTEM (SR7)              STUDENT                 94,  12 / AA
                                                 IX-STUD-LNAME
                                                 DESC DBKEY DL
                                                 N  MA MODE = INDEX

Use of SET-ORDER(N) always reserves a position in the set description, even when there are not enough sort or index keys to actually need it.

Field Names for the DSETLINE and XSETLINE Statements

Field Name	Size (# of chars)	Descriptions
SET-NAME	16	The name of the set.
SET-ORDER	6	The order in which new records are positioned in the set: FIRST, LAST, NEXT, PRIOR, or sorted.
SET-MODE	13	The mode of the set. For regular sets the mode field is left blank. For indexed sets and integrated indexes, the mode field contains MODE = INDEX.
POINTERS	3	The set linkage options: N (next pointers), NP (next and prior pointers), NO (next and owner pointers), or NPO (next, prior, and owner pointers).
MEM-OPT (Membership Options)	2	The disconnect and connect options: MA (mandatory automatic), MM (mandatory manual), OA (optional automatic), or OM (optional manual).
BLANK nn	nn	Name used to specify a blank field.
UN-MEM-OCC-CNT	14	The count of member record occurrences of a record type within the set. The meaning differs slightly for multi-member sets.
UN-MEM-OCC-PCT	3	The percent of member record occurrences of a record type within the set. This is always 100% for single-member sets.
UN-SET-OCC	14	The count of total set occurrences for the set.
UN-SOWM-CNT	14	The count of set occurrences with members for the set.
UN-SOWM-PCT	3	The percent of set occurrences with members for the set.
UN-LOSO-AVG	17	The average length of set occurrences for the set.
UN-LOSO-MAX	14	The maximum length of set occurrences for the set.
UN-LOSO-MIN	14	The minimum length of set occurrences for the set.
UN-PG-SPRD-AVG	17	The average cluster page spread for the set.
UN-PG-SPRD-MAX	14	The maximum cluster page spread for the set.
UN-MEM-OVRF-CNT	14	The count of members on overflow for the set.
UN-MEM-OVRF-PCT	3	The percent of members on overflow for the set.
UN-MEM-OVRF-AVG	17	The average number of members on overflow for the set.
UN-MEM-OVRF-MAX	14	The maximum number of members on overflow for the set.
UN-MEM-OVRF-MIN	14	The minimum number of members on overflow for the set.
UN-PG-CHGS-AVG	17	The average page changes for the set.
UN-PG-CHGS-MAX	14	The maximum page changes for the set.
UN-PG-CHGS-MIN	14	The minimum page changes for the set.
UN-NUM-LVL	14	The number of levels for the index.
UN-BLS-UTE-CNT	14	The count of bottom level statistics used table entries for the index.
UN-BLS-UTE-AVG	17	The average bottom level statistics used table entries for the index.
UN-BLS-UTE-MAX	14	The maximum bottom level statistics used table entries for the index.
UN-BLS-UTE-MIN	14	The minimum bottom level used table entries for the index.
LABEL 'any string' -or- LABEL "any string"	nn	Used to put labels in a record description.

Exhibit 2.8: Field Names for the DSETLINE and XSETLINE Statements