Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Spatial Data User's GuideThe HCL OneDB™ Spatial Data User's Guide contains information to assist you in using the HCL® OneDB® spatial extension. The HCL® OneDB® spatial extension adds custom data types and supporting routines to the server.
Introducing the IBM Informix Spatial DataBlade Module
Update values in a spatial columnYou run the SQL UPDATE statement to alter the values in a spatial column in the same way that you update any other type of column. Typically, you must retrieve spatial column data from the table, alter the data in a client application, and then return the data to the database.

Update values in a spatial column

You run the SQL UPDATE statement to alter the values in a spatial column in the same way that you update any other type of column. Typically, you must retrieve spatial column data from the table, alter the data in a client application, and then return the data to the database.

The following pair of SQL statements illustrates how to fetch the spatial data from one row in the hazardous_sites table and then update the same item:

SELECT ST_AsText(location) FROM hazardous_sites
   WHERE site_id = 102;

UPDATE hazardous_sites 
   SET location = ST_PointFromText('point(18000 57000)', 5)
   WHERE site_id = 102;