Specifying input and output for Unloading and Reloading a DEDB

Selecting areas for input to the unload

The IAREA keyword identifies the names of the areas to be read from the database that is described in the IMSACB library or active directory.

You can specify one or more area names. If you omit the IAREA keyword, all areas that are defined in the DEDB are read.

Multiple areas can be specified on the IAREA keyword by using any combination of area names, area numbers, or a area ranges. The following parameters are available for the IAREA keyword:

• IAREA=ALL (default) or IAREA=* specifies all areas of the DEDB.
• IAREA=areaname specifies one or more areas by using the one-character to eight-character area name for each area specified. Multiple area names must be enclosed in parentheses and separated by commas.
• IAREA=areanumber specifies one or more areas by using the one-character to five-character area number for each area specified. Multiple area numbers must be enclosed in parentheses and separated by commas.
• IAREA=(RANGE=(startarea,endarea)) specifies a consecutive range of areas using either areaname or areanumber parameters. The area associated with startarea must be less than the area number associated with endarea.

An asterisk (*) can be used to specify all areas of the DEDB. When the * character is used with the RANGE keyword, it can be used to specify the beginning or ending range for specific areas of the DEDB.

To unload an entire DEDB, use a command set like the example shown in following figure.

Sample control statement for unloading all areas

To unload specific areas, use a command set like the example shown in following figure.

Sample control statement for unloading specific areas

This control statement uses a combination of area names and area numbers to request that the specified areas are to be input to the unload process. The areas named AREANAM1 and AREANAM3 will be input. Also, all consecutive areas from area number 5 to area number 8 (area5, area6, area7 and area8) will be input to the unload process.

Selecting areas for output

The OAREA keyword identifies the names of the areas to be written from the database that is described in the NEWACB library or staging directory.

You can specify one or more area names. If you omit the OAREA keyword, all areas that are defined in the DEDB are written to the unload file.

Multiple areas can be specified on the OAREA keyword by using any combination of area names, area numbers, or a area ranges. The following parameters are available for the OAREA keyword:

• OAREA=ALL (default) or OAREA=* specifies all areas of the DEDB.
• OAREA=areaname specifies one or more areas by using the one-character to eight-character area name for each area specified. Multiple area names must be enclosed in parentheses and separated by commas.
• OAREA=areanumber specifies one or more areas by using the one-character to five-character area number for each area specified. Multiple area numbers must be enclosed in parentheses and separated by commas.
• OAREA=(RANGE=(startarea,endarea)) specifies a consecutive range of areas using either areaname or areanumber parameters. The area associated with startarea must be less than the area number associated with endarea.

An asterisk (*) can be used to specify all areas of the DEDB. When the * character is used with the RANGE keyword, it can be used to specify the beginning or ending range for specific areas of the DEDB.

Values for the OAREA keyword function in the same manner as for the IAREA keyword. See the examples shown for the IAREA keyword in Sample control statement for unloading all areas and Sample control statement for unloading specific areas.