Reference (DataStage)

These topics describe supported Microsoft Excel types and Microsoft Excel-type-to-DataStage-type mappings and describe job abort conditions.

Properties reference: Excel (DataStage)
This topic lists all properties that you can set to configure the stage.
Data type conversions from Microsoft Excel to IBM DataStage
Before the Excel stage writes data that is extracted from Microsoft Excel to the output link, the data is converted to IBM® DataStage data types.
Data type conversions from DataStage to Microsoft Excel
Before the Excel stage writes data that is extracted from input links to Microsoft Excel files, the data is converted to Microsoft Excel data types.
Job abort conditions in Microsoft Excel (DataStage)
The tables describe the different job abort conditions in Microsoft Excel files.
Consideration about end of wave (DataStage)
In DataStage parallel jobs, some stages can send an end of wave marker (EOW), which indicates the end of a unit of work or transaction. When all the records that are extracted from the input link are included in a unit of work (called a single wave), the Excel stage generates Microsoft Excel sheets that contain the maximum number of records until all of the records are written.

Parent topic: Excel stage in DataStage