IIS-CONN-DB2-00475E Column Column name cannot be used as the partitioning key for minimum and maximum range partitioned reads because it is an unsupported data type. Select a different column or partitioned reads method.

Explanation

Because column Column name is an unsupported data type, it cannot be used as the partitioning key for the partitioned reads when the minimum and maximum range is set.

The Usage > SQL > Enable partitioned reads > Partitioned reads method property is set to minimum and maximum range. When the the range is set, only numeric data types are supported for the partitioning key.

User response

Do one of the following actions:
  • Select a different value for the Usage > SQL > Enable partitioned reads > Partitioned reads method property.
  • Enter a different column in the Usage > SQL >? Enable partitioned reads > Partitioned reads method > Column name property.