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

Example: Reading z/OS Files Downloaded by IBM Sterling Connect:Direct

Example: Reading z/OS Files Downloaded by IBM Sterling Connect:Direct

Although a z/OS file downloaded by IBM Sterling Connect:Direct contains both a leading record length and trailing record terminator bytes, PowerExchange can have difficulties reading such a file for the following reasons:
  • The default record format truncates reads if X'0A' occurs within binary data, such as in an integer or multibyte character field.
  • The leading record length is too small because it does not count the record terminator bytes. The first record can be read with variable type VBP2, but the record boundary is not correct for the second and subsequent records.
A solution includes the following elements:
  • A data map with access method type USER specifies parameters for the file name, size of the length integer, and number of bytes to strip from the end of each record.
  • The user access method library reads the file, gets the length from the first two bytes, removes the specified number of bytes from the end of the record, and writes the record with a length that matches the actual size of the record according to the variable type VBP2.
  • The data map can read the data in a single pass if only one record is being used.
    Multiple-record mappings require two passes. The first pass uses the data map with access method type USER to correct the record lengths, and the second pass uses a data map with access method type SEQ to read the file using variable type VBP2.

0 COMMENTS

We’d like to hear from you!