0 / 0
Column Export stage: Stage tab (DataStage)

Column Export stage: Stage tab (DataStage)

The Column Export Stage tab enables you to control aspects of the Column Export stage.

The Properties section lets you specify what the stage does. The Advanced section allows you to specify how the stage executes.

Properties

Use the Properties section to specify how the Column Export stage operates.
Column method
Select Explicit or Schema file. 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 columns to carry your exported input column. Instead of specifying the source data details through input column definitions, you can use a schema file. If you have defined columns in the Columns section, verify that they match the schema file. Type in a path name or browse for a schema file.
Column to export
Specifies an input column the stage extracts data from. The format properties for this column can be set on the Format tab of the Input page. Repeat the property to specify multiple input columns. You can use the Column Selection dialog box to select multiple columns at once if required. The order of the Columns to Export that you specify should match the order on the Columns tab. If it does not, the order on the Columns tab overrides the order of the properties.
Export output column
Specifies the name of the single column to which the input column or columns are exported.
Export column type
Specify either binary, VarChar (string), or Unicode VarChar (ustring).
Reject mode
The values of this property specify the following actions:
  • Output. The stage continues when it encounters a reject record and writes the record to the rejects link.
  • Continue(warn). The stage is to continue but report failures to the log file.
Keep exported columns
Select True to keep the exported columns or False if you do not want to save the exported columns.

Advanced

Specify the following advanced properties:
  • Execution Mode. The stage can execute 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. This is Propagate by default. It adopts Set or Clear from the previous stage. You can explicitly select Set or Clear. Select Set to request that next stage in the job should attempt to maintain the partitioning.
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