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

----------------------------------------------------------------------------
-- setup.sql
--
-- This script should be run before any of the sql examples.
--
-- It will create an entry in the spatial_references table which
-- is used by many of the sql examples.
----------------------------------------------------------------------------


DELETE FROM spatial_references WHERE srid = 1000;

INSERT INTO spatial_references
     (srid, falsex, falsey, xyunits, falsez, zunits, falsem, munits, srtext)
  VALUES
     (1000, -50000, -50000, 1000, -50000, 1000, -50000, 1000, 'UNKNOWN');