Document toolboxDocument toolbox

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.