ST_WKBtoWKT function

The WKBtoWKT function takes a well-known-binary (WKB) representation of a geography and returns the corresponding geometry in a well-known-text (WKT) format.

If the given well-known binary representation is null, then null is returned.

The ST_WKTtoWKB function gives the same result as ST_AsBinary(ST_GeomFromText()).

Syntax

Read syntax diagramSkip visual syntax diagram db2gse.ST_WKBtoWKT ( geometry ,srsId )

Parameter

geometry
A value of type BLOB(2G) that contains the WKB representation of the geometry to be converted.
srsId
A value of type INTEGER that uniquely identifies the spatial reference system.

Return type

Returns a type CLOB(2G) that contains the WKT representation of a geometry object.