Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Determining Record Boundaries on Linux, UNIX, and Windows

Determining Record Boundaries on Linux, UNIX, and Windows

On Linux and UNIX, text data records are delimited by the single record terminator character LF (X'0A'). On Windows, text data records are delimited by the CR/LF (X'0D0A') two-character sequence. Typically, text files do not contain integers that might conflict with the terminator X'0A' characters. Instead, they usually contain data in display format that you can view by using a text editor such as notepad or vi.
For text files, select the
Default
record format. Also select this format when field boundaries are identified by using delimiters (for example, commas in CSV files). When text files are transferred by using FTP, typically the ASCII option is used, which is the default.
If a file contains binary data such as integer, packed decimal, or float, then select
Fixed
or
Variable
as the record format so that the system can determine record boundaries without the boundaries being affected by the data within each record. When the file is transferred by using FTP, the BINARY option must be used.

0 COMMENTS

We’d like to hear from you!