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

Record Format

Record Format

On the
SEQ Access Method
tab of the
Data Map Properties
dialog box, you select one of the following record formats:
  • Fixed
  • Variable
  • Default
Select
Fixed
or
Variable
only when Linux, UNIX or Windows files contain binary data and the record boundaries are not determined by record delimiter characters. Record delimiter characters are line feed (LF) on Linux and UNIX and carriage return / line feed (CR/LF) on Windows.
If all records have the same length, select
Fixed
for the record format and specify the size of each record.
If the records have variable lengths that are determined by integer record prefixes within the file, select
Variable
for the record format and specify the type of record prefix. For example, you can use a type of VBP2 with z/OS records that are downloaded by using FTP with the BINARY and the QUOTE SITE RDW options.
In all other situations, Informatica recommends that you select the
Default
record format so that the file APIs for the operating system determine the redord length. Specify the
Default
record format for the following kinds of files:
  • i5/OS files
  • z/OS files
  • Linux, UNIX and Windows files where the record boundaries are found through the delimiter characters LF or CR/LF
  • Linux and UNIX named pipes

0 COMMENTS

We’d like to hear from you!