Rejecting records

Records that contain invalid syntax or an incorrect number of fields or invalid field values can be rejected without aborting the load.

A record is considered to have invalid syntax if a field within it contains a quoted value with some characters outside of the quotes or if a quoted field contains non-escaped quotes within the data.  The ‘Q’ switch is used to disable quotation recognition.

A record can be rejected if the number of fields is incorrect. This is specified by the ‘r’ switch.

A record can be rejected if a given field is empty or if it does not contain a given value or falls outside of a size constraint and any number of fields can be constrained in this way. A constraint on field size can require a field contain a specific number of characters or a minimum number of characters or a maximum number of characters. If the field falls outside of any of these constraints the record is rejected. The ‘k’ and ‘K’ switches are used to define these rules.

The number of reject records that cause the load to abort is defined using the ‘x’ and ‘X’ switches. By default, a load aborts at the first rejected record.  


Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk