/
Fixed Width Sequential File With Line Termination

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

 

Related content

Sequential File Incomplete Column Abort
Sequential File Incomplete Column Abort
More like this
VarChar Null and Empty Overlap
VarChar Null and Empty Overlap
Read with this
Sequential File with Omit Last NewLine
Sequential File with Omit Last NewLine
More like this
Sequential File Incomplete Column Handling
Sequential File Incomplete Column Handling
Read with this
Sequential File with Suppress Truncation Warnings
Sequential File with Suppress Truncation Warnings
More like this
Sequential File Stage
Sequential File Stage
More like this

© 2015-2024 Data Migrators Pty Ltd.