IIS-CONN-JAVA-00025W The value of field value for field column is either too small or too large to fit into the SQL type of the column type.
Explanation
The value that is specified is not within the range
for the SQL type of the column.
Find below the list of minimum and
maximum value for numeric type of the InfoSphere® DataStage® column:
- Float or Real
- Minimum: -3.4028234663852886E38f
- Maximum: 3.4028234663852886E38f
- BigInt(Unsigned)
- Minimum: 0
- Maximum: 18446744073709551615
- BigInt
- Minimum: -9223372036854775808
- Maximum: 9223372036854775807
- Integer(Unsigned)
- Minimum: 0
- Maximum: 4294967295
- Integer
- Minimum: -2147483648
- Maximum: 2147483647
- SmallInt(Unsigned)
- Minimum: 0
- Maximum: 65535
- SmallInt
- Minimum: -32768
- Maximum: 32767
- TinyInt(Unsigned)
- Minimum: 0
- Maximum: 255
- TinyInt
- Minimum: -128
- Maximum: 127
- Bit
- Minimum: 0
- Maximum: 65535
User response
Specify a valid value for the InfoSphere DataStage row.