Hi

I am using IBM informix spatial datablade module for some geo specific data. I am trying to find points in table xmlData lying in a specified region. But i am getting this error for select statement.

SELECT sa.pre, sa.post 
FROM xmlData sa 
WHERE ST_Contains( ST_PolyFromText('polygon((2 2,6 2,6 6,2 6,2 2))',6),sa.point)

    Query:
    select count(*) as mycnt fromText('polygon((2 2,6 2,6 6,2 6,2 2))',6),sa.point)
    Error: -201
    [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. (SQLPrepare[-201] at /work/lwchan/workspace/OATPHPcompile/pdo_informix/pdo_informix/informix_driver.c:131) 

If any one can help me with this.

 CREATE TABLE xmlData (row_id integer NOT NULL,
     x   integer,
     y   integer,         
     tagname   varchar(40,1),    
     point ST_POINT
     );


    EXECUTE FUNCTION SE_CreateSRID(0, 0, 250000, 250000,
                                   "use the return value in next query last column");

    INSERT INTO geometry_columns
              (f_table_catalog, f_table_schema, f_table_name,
               f_geometry_column, geometry_type, srid)

       VALUES ("mydatabase",         -- database name
               "informix",           -- user name
               "xmlData",            -- table name
               "point",              -- spatial column name
                1,                   -- column type (1 = point)
                6);                  -- srid //use value returned by above query.

    INSERT INTO xmlData VALUES (
        1, 20,20, 'country',
        ST_PointFromText('point (20 20)',6)
    );

    INSERT INTO xmlData VALUES (
        1, 12,13, 'sunday',
        ST_PointFromText('point (12 13)',6)
    );

    INSERT INTO xmlData VALUES (
        1, 21,22, 'monday',
        ST_PointFromText('point (21 22)',6)
    );


SELECT sa.pre, sa.post 
FROM xmlData sa
WHERE ST_Contains(
      ST_PolyFromText('polygon((1 1,30 1,30 30,1 30,1 1))', 6),sa.point);

I am using following query as reference "ibm link".

SELECT name, type, zone FROM sensitive_areas
   WHERE SE_EnvelopesIntersect(zone,
      ST_PolyFromText('polygon((20000 20000,60000 20000,60000
60000,20000 60000,20000 20000))', 5));