|
Query name |
Fixed Width Sequential File With Line Termination |
|---|---|
|
Server Asset Type |
Sequential File stage |
|
Analysis Type |
Advisory |
|
Description |
Checks if a Sequential file stage in a Server job is set to Fixed Width and has Line Endings NOT set to “none”. |
Issue
The DataStage Parallel Engine will throw a runtime error if the last line from a file does not include line endings consistent with the previous rows.
Actions
If the source file has no line endings on the final line you can either …
-
modify the upstream job to include the line ending on the final row of the file, or
-
allow the file to be generated by the upstream process and add the final line ending by way of a post-generation routine or script.
See also