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

-- The ST_AsText function converts the hazardous_sites location point
-- into its text description.

CREATE TABLE hazardous_sites (site_id   integer,
                              name      varchar(40),
                              location  ST_Point);

INSERT INTO hazardous_sites VALUES(
     102, 'W. H. Kleenare Chemical Repository',
     ST_PointFromText('point (1020.12 324.02)',1000)
);

SELECT site_id, name, ST_AsText(location) Location
   FROM hazardous_sites;