DATAVALIDATEACT
The DATAVALIDATEACT parameter enables additional validation of data types that are not converted from source data to a different SQL data type. This parameter controls whether additional data type validation occurs and identifies the action for the Classic data server to take if a validation error occurs due to badly-formed data.
Specification
Use: Global configuration parameter for the Classic data server.
Data type: INT
Default: 0 = NO VALIDATION
Valid values: 0 - 3
- 0 = NO VALIDATION
- The data is not checked. This is the default
- 1 = REPAIR
- The Classic data server changes non-valid data as described in the table below, and the SQL statement ends successfully with a SQL_SUCCESS_WITH_INFO return code. One or more 002f0002 warning messages are also returned to the client application. A 002f0002 warning message is returned for each column and each row that is changed. The Classic data server does not write any log messages to indicate that conversion errors occurred.
- 2 = REPAIR REPORT
- The Classic data server processes the validation error as the REPAIR option describes. The Classic data server also writes the data conversion error message x002f0001 to the server log for each row that contains one or more conversion errors.
- 3 = FAIL
- The query ends with a -4908 return code that indicates non-valid mapped data.
| Data type value | SQL data type | Data validated | Repair value |
|---|---|---|---|
| P | DECIMAL | Packed decimal data | -9 |
| V | VARCHAR | Field length | 0: For a negative length value Maximum length: If the length is greater than the maximum length of the field |
| VB | VARBINARY | Field length | 0: For a negative length value Maximum length: If the length is greater than the maximum length of the field |
| UP | DECIMAL | Packed positive number | -9 |
| UF | INTEGER | Value between 0 and X'7FFFFFFF' | -9 |
| UH | SMALLINT | Value between 0 and X'7FFF' | -9 |