0 / 0

Job abort conditions in Microsoft Excel (DataStage)

Last updated: Mar 12, 2025
Job abort conditions in Microsoft Excel (Excel stage)

The tables describe the different job abort conditions in Microsoft Excel files.

n

Note: The following condition applies only when the Excel stage reads records from the Microsoft Excel files.
File name (wildcard character is not used)
When file name is used without wildcard character, the following job abort conditions can occur:
Table 1. File name (wildcard is not used)
Condition Result
The specified file does not exist. Job aborts.
User does not have permission to read the specified file. Job aborts.
The specified file is not a valid Microsoft Excel file. Job aborts.
The file cannot be opened by specified password. Job aborts.
File name (wildcard character is used)
When file name is used with wildcard character, the following job abort conditions can occur:
Table 2. File name (wildcard is used)
Condition Result
There is no file with the specified name. The job continues with a warning message (no output row).
User does not have permission to read a matched file. The job continues with a warning message if the Error action property is set to Skip. Otherwise, the job aborts.
The matched file is not a valid Microsoft Excel file. The job continues with a warning message if the Error action property is set to Skip. Otherwise, the job aborts.
The matched file cannot be opened by the specified password. The job continues with a warning message if the Error action property is set toSkip. Otherwise, the job aborts.
Sheet Name
The following job abort conditions can occur for sheet name:
Table 3. Sheet name
Condition Result
Sheet name is specified in data range, and the sheet does not exist. The job continues with a warning message if the Error action property is set to Skip. Otherwise, the job aborts.
Column header
The following job abort condition can occur for column header:
Table 4. Column header
Condition Result
First row is column header and the value of first row does not match the value of the first row of the template data range. The job continues and an informational message is logged.
Data type
The following job abort conditions can occur for data type:
Table 5. Data type
Condition Result
The data type is not supported to extract the Microsoft Excel object type mapped to the DataStage® column The job aborts.
The data type is supported to extract the Microsoft Excel object type mapped to the DataStage column, but does not match the instance (This happens when the Microsoft Excel object is a cell or a custom property). The job continues with a warning message if the Error action property is set to Skip. Otherwise, the job aborts.
Custom property
The following job abort condition can occur for custom property:
Table 6. Custom property
Condition Result
The specified property does not exist. The job continues with a warning message if the Error action property is set to Skip. Otherwise, the job aborts.