Make Subrecord stage: Stage tab (DataStage)

You can specify aspects of the Make Subrecord stage from the Make Subrecord stage: Stage page.

Specify what the stage does in the Properties section. Use the Description section to specify an optional description of the stage. Specify how the stage runs in the Advanced section.

Make Subrecord stage: Properties section

Use the Properties section to specify how the Make Subrecord stage operates.

Some of the properties are mandatory, although many have default settings. Properties without default settings appear in the warning color (red by default) and turn black when you supply a value for them.

The following table gives a quick reference list of the properties and their attributes.

Table 1. Properties
Category/Property	Values	Default	Mandatory?	Repeats?	Dependent of
Options/Subrecord Output Column	Output Column	N/A	Y	N	N/A
Options/Vector Column for Subrecord	Input Column	N/A	N	Y	Key
Options/Disable Warning of Column Padding	True/False	False	N	N	N/A

Subrecord Output Column: Specify the name of the subrecord into which you want to combine the columns specified by the Vector Column for Subrecord property.

Vector Column for Subrecord: Specify the name of the column to include in the subrecord. You can specify multiple columns to be combined into a subrecord. For each column, specify the property followed by the name of the column to include. You can use the Column Selection dialog box to select multiple columns at the same time if necessary.

Disable Warning of Column Padding: When the stage combines vectors of unequal length, it pads columns and displays a message to this effect. Optionally specify this property to disable display of the message.

Make Subrecord stage: Advanced section

Use this section to specify options.

You can specify the following options:

- Execution Mode. The stage can run in parallel mode or sequential mode. In parallel mode the input data is processed by the available nodes as specified in the Configuration file, and by any node constraints specified on the Advanced tab. In Sequential mode the entire data set is processed by the conductor node.
- Combinability mode. This is Auto by default, which allows IBM® DataStage® to combine the operators that underlie parallel stages so that they run in the same process if it is sensible for this type of stage.
- Preserve partitioning. The default setting is Propagate. The setting adopts Set or Clear from the previous stage. You can explicitly select Set or Clear. Select Set to request that the next stage in the job attempt to maintain the partitioning.