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)))