Navigator User Guide

Back Next

Field Properties - Field Checking

View or edit field checking properties for a field.

Select Field for checking?: Select one of the following options to specify how PowerExchange complete data checking for the field:

Use Data Map rules
. Use the data checking properties defined for the data map.

Yes
. Use field checking.

No
. Do not use field checking.

Default is
Use Data Map rules
.
How do you want to handle a Field error?: Select one of the following options to specify how PowerExchange handles errors in field data:

Use Data Map rules
. Use the data checking properties defined for the data map.

Replace with default values
. For CHAR fields, replace data by using the values on the
Data Defaults
tab in the
Data Map Properties
dialog box. You can specify whether to replace the first character or all characters in the field. PowerExchange sets values in numeric fields to zeros.

Skip field and write log file
. Skip the field, write a message to the log file, and continue extraction processing.

Terminate the data extract
. Stop extraction processing.

Set to NULL
. Set the field to NULL.

Default is
Use Data Map rules
.