Installs additional features that were not present in the database when SQL Anywhere was installed.
sa_install_feature(' feat_name ')
feat_name A LONG VARCHAR parameter that identifies the feature to install. The supported feature names are:
Value | Description |
---|---|
st_geometry_predefined_uom | Installs many predefined units of measure that are not installed by default in new databases. |
st_geometry_predefined_srs | Installs many predefined spatial reference systems and units of measure that are not installed by default in new databases. |
st_geometry_compat_func | Installs a set of spatial compatibility functions. These functions can be used as an alternative to the spatial methods. See Spatial compatibility functions. |
Feature name definitions are provided in the st_geometry_config.tgz file located in the scripts directory. If the file is removed and you attempt to install features that are dependent on the file, an error is returned.
You can query the feat_name value to see what will be installed. For example, the following query returns the units of measure that would be installed for st_geometry_predefined_uom.
SELECT * FROM dbo.st_geometry_predefined_uom('CREATE'); |
The previous example also shows you parameter names so you can query for specific values using a WHERE clause. For example, the following statement queries the unit_name parameter for the chain unit of measure:
SELECT * FROM dbo.st_geometry_predefined_uom('CREATE') WHERE unit_name='chain'; |
unit_name | unit_type | conversion_factor | ... |
---|---|---|---|
chain | LINEAR | 20.1168 | ... |
The following returns all units of measure that are based on foot:
SELECT * FROM dbo.st_geometry_predefined_uom() WHERE unit_name LIKE '%foot%'; |
Use the following query to find the spatial reference systems that would be installed:
SELECT * FROM dbo.st_geometry_predefined_srs(); |
The following statement queries for an SRS by organization_name and organization_coordsys_id:
SELECT * FROM dbo.st_geometry_predefined_srs() WHERE organization='EPSG' AND organization_coordsys_id=2295; |
DBA or be a member of the SYS_SPATIAL_ADMIN_ROLE group
The following statement installs all of the predefined units of measure that are not installed by default in a new database:
CALL sa_install_feature('st_geometry_predefined_uom'); |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |