Considerations for spatial functions

Before a spatial function can be called, its name must be qualified by the name of the schema to which the spatial functions belong. This schema is DB2GSE. One way to do this is to explicitly specify the schema in the SQL statement that references the function, as in the following example:

CREATE TABLE CUSTOMERS ( ..., LOCATION DB2GSE.ST_POINT, ... ) ;
ALTER TABLE BRANCHES ADD COLUMN LOCATION DB2GSE.ST_POINT;

Alternatively, to avoid specifying the schema each time a function is to be called, you can add DB2GSE to the CURRENT PATH special register. To obtain the current settings for this special register, use the following SQL statement:

 SELECT CURRENT PATH FROM SYSIBM.SYSDUMMY1;

To update the CURRENT PATH special register with DB2GSE, use the following SQL statement:

set CURRENT PATH = CURRENT PATH, db2gse;