User's Guide and Reference

ST_MPointFromText

ST_MPointFromText takes a well-known text representation of type multipoint and a spatial reference system identity and returns a multipoint.

Syntax

db2gse.ST_MPointFromText(multiPointTaggedText Varchar(4000), cr db2gse.coordref)

Return type

db2gse.ST_MultiPoint

Examples

The following CREATE TABLE statement creates the MULTIPOINT_TEST table with a single multipoint column, MPT1.

CREATE TABLE MULTIPOINT_TEST (mpt1 db2gse.ST_MultiPoint) 

The following INSERT statement inserts a multipoint into the MPT1 column by using the ST_MPointFromText column.

INSERT INTO MULTIPOINT_TEST
VALUES (1, db2gse.ST_MPointFromText('multipoint(10.01 20.03,10.52 40.11,
                                    30.29 41.56,31.78 10.74)',
                         db2gse.coordref()..srid(0)))


[ Top of Page | Previous Page | Next Page ]