This section specifies the minimum steps to take to get a Column Export stage
functioning.
Procedure
- On the Stage tab, choose the Column method. It is Explicit by
default, meaning you specify explicitly choose input columns as sources. The alternative is to
specify a schema file.
- If you are using the Explicit method, choose the input column(s) to carry your exported
input column. Repeat the Column to Export property to specify all the columns you need.
- If you are using the Schema File method, specify the schema file that gives the output
column details. Under the Output category:
- Choose the Export Column Type. This is Binary by default, but you can also choose
VarChar or Unicode VarChar. This specifies the format of the column you are exporting
to.
- Specify the column you are exporting to in the Export Output Column
property.
- On the Input tab, in the Format section,
specify the format of the column you are exporting. This informs IBM® DataStage® about
delimiters and enables it to combine multiple columns into a single column with
delimiters.
- On the Output tab, click Edit in the
Columns section. In the Maps from input column section, check that the input
columns are mapping onto the output columns as you expect. The mapping is carried out according to
what you specified in the Properties section.