GSE3004N Unsupported conversion to unit unit-name.

Explanation

The conversion to the unit unit-name is not supported.

The functions ST_Area, ST_Buffer, ST_Length, and ST_Perimeter cannot accept a linear unit of measure if the given geometry is not in a projected coordinate system.

User response

Use one of the following methods:
  • Omit the unit of measure when calling the spatial function or method.
  • Specify an angular unit of measure.
  • Project the geometry into a projected coordinate system using the ST_Transform function. Consult the IBM® Spatial Support for Db2® for z/OS® catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS for applicable spatial reference system.

msgcode: -3004

sqlstate: 38SU4