HSSREXTR input data set for FABHEXTR

An HSSREXTR DD statement is required by the FABHEXTR exit routine.

This DD statement must point to a sequential data set or to a member of PDS, which contains control statements.

The data set must contain either an EXTR control statement or a PARTEXTR control statement. If it contains an EXTR control statement, it can also contain a SKIP control statement. A PARTEXTR control statement can be specified only for HALDB.

Figure 1. HSSREXTR control statements
   //HSSREXTR DD   *
   EXTR nnnnnnnn
   SKIP mmmmmmmm
or 
   //HSSREXTR DD   *                
   PARTEXTR nnnnnnnnn
Subtopics:

EXTR control statement

The EXTR control statement specifies the number of consecutive database records to be extracted.

The EXTR control statement must have the following format:

  • Columns 1 - 4 must contain EXTR.
  • Column 5 must contain a blank.
  • The number of consecutive database records to be extracted must be coded from column 6 onward. The number must be less than or equal to 999999999.

SKIP control statement

The SKIP control statement specifies the number of database records to be skipped.

The optional SKIP control statement that can be specified with the EXTR control statement must have the following format:

  • Columns 1 - 4 must contain SKIP.
  • Column 5 must contain a blank.
  • The number of database records to be skipped at the beginning of the database must be coded from column 6 onward. The number must be less than or equal to 999999999.

PARTEXTR control statement

The PARTEXTR control statement specifies the number of consecutive database records to be extracted from each HALDB partition.

The PARTEXTR control statement must have the following format:

  • Columns 1 - 8 must contain PARTEXTR.
  • Column 9 must contain a blank.
  • The number of consecutive database records to be extracted from each HALDB partition must be coded from column 10 onward. The number must be less than or equal to 999999999. No leading zeros need to be specified, but the number must be left-aligned. This control statement is valid only for HALDB. If the number of database records in a partition is less than the number specified in the PARTEXTR control statement, all records in the partition are unloaded.
  • You cannot specify more than one PARTEXTR control statement.
  • If the PARTEXTR control statement is specified, you cannot specify both the EXTR and SKIP control statement concurrently.