Data Validation
The runtime adapter performs data validation. You can check the following table for the valid format and range of each data type. When a field contains data that does not conform to the format or data whose value is beyond the valid range, the entire record is discarded and an error message is logged.
| Data Type | Format | Valid Range |
|---|---|---|
| i1 | [whitespace][{+|-}][digits] | <-128,127> |
| i2 | [whitespace][{+|-}][digits] | <-32768,32767> |
| i4 | [whitespace][{+|-}][digits] | <-2147483648,2147483647> |
| i8 | [whitespace][{+|-}][digits] | <-9223372036854775808,92233720368547758 07> |
| ui1 | [whitespace][+][digits] | <0,127> |
| ui2 | [whitespace][+][digits] | <0,32767> |
| ui4 | [whitespace][+][digits] | <0,2147483647> |
| ui8 | [whitespace][+][digits] | <0,9223372036854775807> |
| r4 | [whitespace][sign][digits][. digits][{e|E}[sign]digits] | <1.175494351e-38,3.402823466e+38> |
| r8 | [whitespace][sign][digits][. digits][{e|E}[sign]digits] | <2.2250738585072014e-308,1.7976931348623158e+308> |
| DataTime | A list of predefined patterns and an option to specify user-defined patterns are available. If the user-defined pattern option is enabled, you can use User-Defined Pattern to specify the pattern. For syntax and semantics for specifying the pattern, see Syntax for Specifying User-defined Date and Time Patterns. |
Copyright © Cloud Software Group, Inc. All rights reserved.