User's Guide and Reference

ST_MLineFromText

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

Syntax

db2gse.ST_MLineFromText(multiLineStringTaggedText String, cr db2gse.coordref)

Return type

db2gse.ST_MultiLineString

Examples

The following CREATE TABLE statement creates the MLINESTRING_TEST table. MLINESTRING_TEST has two columns: the GID smallint column, which uniquely identifies the row, and the ML1 multilinestring column.

CREATE TABLE ST_MLINESTRING_TEST (gid smallint, ml1 db2gse.ST_MultiLineString) 

The following INSERT statement inserts the multilinestring with the ST_MLineFromText function.

INSERT INTO MLINESTRING_TEST
VALUES (1, db2gse.ST_MLineFromText('multilinestring((10.01 20.03,10.52 40.11,30.29 41.56,
                                          31.78 10.74),
                                         (20.93 20.81, 21.52 40.10))',
                         db2gse.coordref()..srid(0)))


[ Top of Page | Previous Page | Next Page ]