Fixed Width Sequential File With Line Termination
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
© 2015-2024 Data Migrators Pty Ltd.