RECORD definition statement

The RECORD definition statement (RECORD statement) must be specified on the first line of a member of the FABGRECI data set. The RECORD statement can be followed by one or more FIELD statements.

Subsections:

Syntax

The following syntax diagram shows the keywords for the RECORD statement.

Read syntax diagramSkip visual syntax diagramRECORD TYPE=DBPARTDSGSEGMENTRAPPOINTER ,RECID= xx ,DSGID= nn

Keywords

The following keywords can be specified on the RECORD statement:

TYPE=
Required. Specifies the type of flat record.
DB
Specifies to generate the flat record for each database. The fields contained in this record show the information of whole database.

FIELD NAME=DBDNAME statement must be specified for this record type.

PART
Specifies to generate the flat record for each partition of HALDB. It can be specified to a HALDB. The fields contained in this record show the information of each partition.

FIELD NAME=PARTID statement must be specified for this record type.

DSG
Specifies to generate the flat record for each data set group. The fields contained in this record show the information of each data set group.

For HALDB, the flat record is generated per data set group and per partition. For example,

  • If three data set groups are defined to non-HALDB, three flat records are created.
  • If three data set groups are defined to HALDB and two partitions are defined to the HALDB, six flat records are created in total.

FIELD NAME=DSGID must be specified for this record type.

SEGMENT
Specifies to generate the flat record for each segment type. The fields contained in this record show the information of each segment type.

For HALDB, the flat record is generated per segment type and per partition.

FIELD NAME=SEGNAME statement must be specified with this record type.

RAP
Specifies to generate the flat record for each RAP (Root Anchor Point). The fields contained in this record show the information of RAP.

For HALDB, the flat record is generated per partition.

FIELD NAME=PTRTYPE must be specified with this record type.

POINTER
Specifies to generate the flat record for each the pointer types. The fields contained in this record show the information of each pointer type. For HALDB, the flat record is generated per pointer type and per partition.

FIELD NAME=PTRTYPE must be specified for this record type.

RECID=xx
Required. Specifies an identifier for the flat record. xx is two alphanumeric characters. This ID can be stored in the flat record.
DSGID=nn
Optional. Specifies a data set group number. nn is one of decimal numbers from 1 to 10. If this parameter is not specified, the flat records are generated from all of the data set groups. If this parameter is specified, the flat records are generated from the specified data set group.

In case of HALDB, the data set group is usually referred to by an alphabet (A, B, ... or, J). However, specify this parameter by a decimal number. For example, to process data set group A, specify DSGID=1. The flat records are generated for the specified data set group for every partition. You can only specify DSGID=nn when TYPE=DSG is specified.