Navigator User Guide

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Data Map Properties - Data Checking

View or edit data checking properties for a data map.

How do you want to handle Record Mapping Errors?

Select one of the following options to specify how PowerExchange handles record mapping errors:

Skip row and write log file msg

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

Terminate the data extract

. Stop extraction processing.

Default is

Terminate the data extract

How do you want to handle Bad Field Data?

Select one of the following options to specify how PowerExchange handle data that is not valid in fields:

Replace according to data defaults

. For CHAR or DATE 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 zeros.

Skip row and write log file msg

. Skip the row, 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

Terminate the data extract

Check Field Types

Select the field types for which you want to perform validation. PowerExchange performs the following types of validation for the following field types:

CHAR: For EBCDIC and ASCII character sets, PowerExchange validates that the field contains only the following characters:

0 through 9

A through Z

a through z

Greater than sign (>)

Less than sign (<)

Equals sign (=)

Space ( )
DATE: PowerExchange validates that the field uses the PowerExchange-defined DATE format.
NUMCHAR: PowerExchange validates that the field contains only the following characters:

0 through 9

Asterisk (*)

Comma (,)

Decimal point (.)

Dollar sign ($)

Forward slash (/)

Minus sign (-)

Plus sign (+)

Space ( )
PACKED: PowerExchange validates that the field contains only standard packed decimal format (S9 COMP-3) characters.

If you do not enable data checking for this field type, and any half byte of data other than the last half byte (which contains the sign) contains a value other than 0-9, PowerExchange interprets the field as having a NULL value. If the session writes to a nonrelational target, and the data map for the target does not allow NULL values, the session fails.

For example, if data checking of packed decimals is not enabled, and a 2-byte packed decimal field in the source data is defined as PIC S9(3) COMP-3, PowerExchange passes the following values to PowerCenter:

X'FFFF' - NULL is passed to PowerCenter
X'0000 - 0 is passed to PowerCenter
X'4040' - 404 is passed to PowerCenter
X'F00C - NULL is passed to PowerCenter

To prevent the session from failing, enable data checking for packed decimal fields, and select the appropriate option for your situation at
How do you want to handle Bad Field data?
TIME: PowerExchange validates that the field uses the PowerExchange-defined TIME format.
TIMESTAMP: PowerExchange validates that the field uses the PowerExchange-defined TIMESTAMP format.
ZONED: PowerExchange validates that the fields uses only zoned numeric, 0 through 9, and sign (-) characters.