analytics/informix/extend/spatial.8.22.FC2/examples/sql/st_linefromtext.sql

-- The linestring_test table is created with a single ln1 ST_LineString column.

CREATE TABLE linestring_test (ln1 ST_LineString);

-- The INSERT statement inserts a ST_LineString into the ln1 column
-- using the ST_LineFromText function.

INSERT INTO linestring_test VALUES(
   ST_LineFromText('linestring(10.01 20.03,20.94 21.34,35.93 19.04)',1000)
);