Previous Topic: Placement of Multiple CALC KeysNext Topic: XRECLINE Statement


Sample DRECLINE Statements and Resulting Record Blocks

To Create A Three-Line Record Block:

To create a three-line record block that has the record name on line 1, the area and location mode on line 2, and the record size and description on line 3, use these statements:

DRECLINE REC-NAME
DRECLINE AREA,LOC-MODE
DRECLINE LENGTH,REC-DESC

A resulting record block looks like this:

*************************************************
*             SPORTS                            *
*         STUDENT-REGION            CALC        *
*  32    NON-COMPETITIVE AND COMPETITIVE SPORTS *
*************************************************

To Create A Six-Line Record Block:

To create a six-line record block that has the record name on line 1, a blank second line, the area, location mode, and record size on line 3, the description on line 4, the duplicates option on line 5, and the location control on line 6, use these statements:

DRECLINE REC-NAME
DRECLINE
DRECLINE AREA,LOC-MODE,LENGTH
DRECLINE REC-DESC
DRECLINE DUPS-OPT
DRECLINE LOC-CTRL

Here is a resulting record block:

****************************************************
*             SPORTS                               *
*                                                  *
*         STUDENT-REGION           CALC        32  *
* NON-COMPETITIVE AND COMPETITIVE SPORTS           *
*               DN                                 *
*           SPORT-NAME                             *
****************************************************

To Create Blank Fields or Blank Lines for Handwritten Notes or Graphic Appeal:

A record block with a blank second line and a blank, 10-character field in line 3 is specified like this:

DRECLINE REC-NAME
DRECLINE
DRECLINE AREA,BLANK 10,LOC-MODE
DRECLINE LENGTH,REC-DESC

Note: You must put a space between the word BLANK and the blank field length. Leaving out the space results in an error message.

Here is a record block with the above format:

****************************************************
*             SPORTS                               *
*                                                  *
*         STUDENT-REGION                      CALC *
*  32    NON-COMPETITIVE AND COMPETITIVE SPORTS    *
****************************************************

To Combine Explicit and Implicit Placement of CALC Keys:

A record block with the first CALC key on the second line and additional CALC keys on the last lines is specified like this:

DRECLINE REC-NAME,LOC-MODE
DRECLINE LOC-CTRL(1)
DRECLINE AREA
DRECLINE LOC-CTRL(N)

Here is a resulting record block:

*************************************
*        STUDENT           CALC     *
*             STUD-ID               *
*          STUDENT-REGION           *
*            STUD-LEVEL             *
*              STUD-PA              *
*              STUD-MA              *
*************************************

Use of LOC-CTRL(N) always reserves a position in the record block, even when there are not enough CALC keys to actually need it.

Field Names for the DRECLINE and XRECLINE Statements

Field Name

Size
(# of chars)

Description

REC-NAME
(record name)

16

The name of the record type.

LOC-MODE

6

How records of this type are physically located in their areas: CALC, VIA, or DIRECT

AREA

16

The name of the area in which the record type is located.

LENGTH

(record size)

6

The actual data length of the record (if fixed length) or the maximum data length of the record (if variable length), in bytes. If the value obtained from the dictionary is less than 1, CA IDMS Schema Mapper uses a value of 1 in the record block. This happens, for example, when a schema record is defined without any elements and is consistent with the value reported by IDMSRPTS or RECDES.

LENGTH-MODE

2

The four record modes: F (fixed), V (variable), FC (fixed compressed), or VC (variable compressed).

DUPS-OPT
(Duplicates Option)

2

For CALC records, the disposition of records with duplicate control keys: DN (duplicates not allowed), DF (duplicates first), or DL (duplicates last). This field is blank for non-CALC records.

REC-DESC
(Record Description)

40

The record description field from the dictionary. Provides an alternate (and more descriptive) record name.

LOC-CTRL (Location Control)

32

CALC key name or VIA set name. This is always DIRECT-DBK for DIRECT records.

REC-ID (Record Identification)

4

Unique identification number of record type.

BLANK nn

nn

Name used to specify a blank field.

UN-NUM-OCC

14

The total number of record occurrences for this record type.

UN-OCC-LEN-CAVG

17

The average compress occurrence length for this record type.

UN-OCC-LEN-CMAX

14

The maximum compress occurrence length for this record type.

UN-OCC-LEN-CMIN

14

The minimum compress occurrence length for this record type.

UN-OCC-LEN-DAVG

17

The average decompress occurrence length for this record type.

UN-OCC-LEN-DMAX

14

The maximum decompress occurrence length for this record type.

UN-OCC-LEN-DMIN

14

The minimum decompress occurrence length for this record type.

LABEL 'any string'
-or-
LABEL "any string"

nn

Used to put labels in a record description.

Exhibit 2.5: Field Names for the DRECLINE and XRECLINE Statements