Example 1

In this example the input data comprises a single column carrying a vector. The example assumes that the job is running sequentially. The input data set has a single column called 'col'..

The following are some rows from the input data set:
Table 1. Input data set
Vector index 0 1 2 3 4
row 3 6 2 9 9
row 3 2 7 2 4
row 7 8 8 5 3
row 4 8 7 1 6
row 1 6 2 5 1
row 0 1 6 7 8
row 9 9 6 4 2
row 0 8 4 4 3
row 1 7 2 5 3
row 7 9 4 7 8
The stage splits the columns it extracts from the vector into separate columns called column_nameN. You do not have to explicitly define the output column names, IBM® DataStage® will do this for you as the job runs, but you might wish to do so to make the job more understandable.
Table 2. Output column names
Column name SQL type
col0 TinyInt
col1 TinyInt
col2 TinyInt
col3 TinyInt
col4 TinyInt

The Vector Column property in the Properties tab is set to 'col'.

The output data set will be:
Table 3. Output data set
  col0 col1 col2 col3 col4
row 3 6 2 9 9
row 3 2 7 2 4
row 7 8 8 5 3
row 4 8 7 1 6
row 1 6 2 5 1
row 0 1 6 7 8
row 9 9 6 4 2
row 0 8 4 4 3
row 1 7 2 5 3
row 7 9 4 7 8