Split Vector stage in DataStage

The Split Vector stage is a restructure stage. It promotes the elements of a fixed-length vector to a set of similarly named top-level columns.

It can have a single input link and a single output link.

The Split Vector stage creates columns of the format name0 to namen, where name is the original vector's name and 0 and n are the first and last elements of the vector.

Shows a vector of columns being split into top-level columns

The Make Vector stage performs the inverse operation (see Make Vector stage in DataStage).

The stage editor has three tabs:

Stage tab. This tab is always present and is used to specify general information about the stage.
Input. This tab is where you specify the details about the single input set from which you are selecting records.
Output. This tab is where you specify details about the processed data being output from the stage.

Input tab

Specify an optional description of the input link in the Description section. In the Partitions section, specify how incoming data is partitioned before being converted. In the Columns section, specify the column definitions of incoming data. In the Advanced section, you can change the default buffering settings for the input link.

Output tab

The Split Vector stage can have only one output link.

Specify an optional description of the output link in the Description section. In the Partitions section, specify how output data is partitioned before being converted. In the Columns section, specify the column definitions of output data. In the Advanced section, you can change the default buffering settings for the output link.