Extract Numbers

Before starting to create extracts, work out an extract numbering system, and set the extract numbers explicitly when the extracts are created.

Extract numbers must be between 1 and 8191 inclusive, for each database. The user must set the range of extract numbers available for normal extracts, and for working extracts at each location (see the diagram below).

Set the range by setting the EXTLO and EXTHI attributes for LOCLI and LOC elements as follows:

• The available numbers for extract databases at a location are defined by the EXTLO and EXTHI attributes for the LOCLI element under the /*GL element. The user must define the range of extract numbers so that there are enough left for working extracts: see next point.

• The available numbers for working extracts at a location are defined by the EXTLO and EXTHI attributes for the LOC elements under the LOCLI element: for each Location you must select a range of numbers which lies within the range you have left for working extracts, and which does not overlap with the range for working extracts at any other Location.

  

To query extract number ranges, navigate to the appropriate element and run the following commands:

Q EXTLO

Q EXTHI

When using the Admin menu bar, use the Location version of the Admin Elements window to create or modify a Location.

On the window, specify the range of numbers available for working extracts at the location.

Refer to Global User Guide for further information.