Navigator User Guide

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

Back Next

CheckNumData

Enables a calling program to check whether a field contains valid numeric characters for field types CHAR, NUMCHAR, ZONED, and PACKED. If the program finds invalid data, it takes additional action.

CheckNumData performs a similar function to the data checking options in the data map properties. CheckNumData applies data checking to a single field, rather than to the entire data map. You can use CheckNumData to validate numeric data fields before conversion processing by a function such as the CopyData function.

Syntax:

CheckNumData(field_name,field_type,action)

The following table describes the parameters:

Parameter	Description
`field_name`	The name of the field to check for valid numeric data.
`field_type`	The datatype of the field to be checked by CheckNumData. The following types are valid: CHAR NUMCHAR ZONED PACKED
`action`	The action to take if invalid data is found in the field for the specified datatype. Options are: REPLACE. Replaces the field value with a specific value that is valid. SETNULL. Replaces the field value with a null character that is valid for the target. SKIP. Skips the field in the target mapping if the field contains invalid data. TERMINATE. Ends the mapping process if invalid data is found.

Rename Saved Search

Table of Contents

Navigator User Guide

Navigator User Guide

CheckNumData

CheckNumData