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

Column Indicators in the Reject File

Column Indicators in the Reject File

In PowerExchange reject files, a column indicator appears after every column of data to define the preceding data.
The following table describes the column indicators that PowerExchange uses:
Column Indicator
Type of Data
Writer Action
D
Valid data
Writer passes the data to the target database. The target accepts the data unless a database error, such as a duplicate key, occurs.
N
Null value
Writer passes the null value to the target. The null value is rejected if the target database does not accept null values.
Null values in reject files are indicated by “N,” for example:
1,D,,N,35,D
Binary values in reject files are indicated by the text string “BINARY DATA,” for example:
0,D,1,D,PAUL ,D,BINARY DATA,D

0 COMMENTS

We’d like to hear from you!