0 / 0
Write Range Map stage in DataStage: Input tab

Write Range Map stage: Input tab

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 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.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more