ST_MPolyFromText takes a well-known text representation of type multipolygon and a spatial reference system identity and returns a multipolygon.
Syntax
db2gse.ST_MPolyFromText(multiPolygonTaggedText Varchar(4000), cr db2gse.coordref)
Return type
db2gse.ST_MultiPolygon
Examples
The following CREATE TABLE statement creates the MULTIPOLYGON_TEST table, which has a single multipolygon column, MPL1.
CREATE TABLE MULTIPOLYGON_TEST (mpl1 db2gse.ST_MultiPolygon)
The following INSERT statement inserts the a multipolygon into the MPL1 column using the ST_MPolyFromText function.
INSERT INTO MULTIPOLYGON_TEST VALUES (
db2gse.ST_MPolyFromText('multipolygon(((10.01 20.03,10.52 40.11,30.29 41.56,31.78
10.74,10.01 20.03),(21.23 15.74,21.34 35.21,28.94 35.35,29.02 16.83,21.23
15.74)),((40.91 10.92,40.56 20.19,50.01 21.12,51.34 9.81,40.91 10.92)))',
db2gse.coordref()..srid(0)))