Write Range Map stage: Input tab (DataStage®)

The Input tab allows you to specify details about how the Write Range Map stage writes the range map to a file. The Write Range Map stage can have only one input link.

The Properties section allows you to specify details of exactly what the link does. The Advanced section allows you to change the default buffering settings for the input link.

Properties

You can specify the following properties:

Table 1. Properties
Category/Property	Values	Default	Mandatory?	Repeats?	Dependent of
Options/File Update Mode	Create/Overwrite	Create	Y	N	N/A
Options/Edit > Key	input column	N/A	Y	Y	N/A
Options/	Ascending/ Descending	Ascending	N	N	Key
Options/	True/False	True	N	N	Key
Options/	First/Last	First	N	N	Key
Options/	True/False	False	N	N	Key
Options/Range Map File	pathname	N/A	Y	N	N/A

File update mode

This is set to Create by default. If the file you specify already exists this will cause an error. Choose Overwrite to overwrite existing files.

Range map file

Specify the file that is to hold the range map. You can browse for a file or specify a job parameter.

Key

This allows you to specify the key for the range map. Choose an input column from the drop-down list. You can specify a composite key by specifying multiple key properties. You can use the Column Selection dialog box to select several keys at once if required). Key has the following dependent properties:

Sort Order: Choose Ascending or Descending. The default is Ascending.

Case Sensitive: This property is optional. Use this to specify whether each group key is case sensitive or not, this is set to True by default, that is, the values “CASE” and “case” would not be judged equivalent.

Nulls Position: This property is optional. By default columns containing null values appear first in the sorted data set. To override this default so that columns containing null values appear last in the sorted data set, select Last.

Sort as EBCDIC: To sort as in the EBCDIC character set, choose True.