User's Guide and Reference

ST_LineFromText

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

Syntax

db2gse.ST_LineFromText(lineStringTaggedText Varchar(4000), cr db2gse.coordref)

Return type

db2gse.ST_LineString

Examples

The following CREATE TABLE statement creates the LINESTRING_TEST table, which has a single LN1 linestring column.

CREATE TABLE LINESTRING_TEST (ln1 db2gse.ST_LineString)

The following INSERT statement inserts a linestring into the LN1 column by using the ST_LineFromText function.

INSERT INTO LINESTRING_TEST
VALUES (db2gse.ST_LineFromText('linestring(10.01 20.03,20.94 21.34,35.93 19.04)',
db2gse.coordref()..srid(0)))


[ Top of Page | Previous Page | Next Page ]