DB2GSE.ST_GEOCODERS catalog view
When you register additional geocoders that you want to make available to users, use the DB2GSE.ST_GEOCODERS catalog view to retrieve information about these registered geocoders.
For information about geocoders' parameters, query the DB2GSE.ST_GEOCODER_PARAMETERS catalog view and the SYSCAT.ROUTINEPARMS catalog view. For information about functions that are used as geocoders, query the SYSCAT.ROUTINES catalog view.
For a description of
columns in DB2GSE.ST_GEOCODERS view, see the following table.
| Name | Data type | Nullable? | Content |
|---|---|---|---|
| GEOCODER_NAME | VARCHAR(128) | No | Name of this geocoder. It is unique within the database. |
| FUNCTION_SCHEMA | VARCHAR(128) | No | Name of the schema to which the function that is being used as this geocoder belongs. |
| FUNCTION_NAME | VARCHAR(128) | No | Unqualified name of the function that is being used as this geocoder. |
| SPECIFIC_NAME | VARCHAR(128) | No | Specific name of the function that is being used
as this geocoder. The combined values of FUNCTION_SCHEMA and SPECIFIC_NAME uniquely identify the function that is being used as this geocoder. |
| RETURN_TYPE_SCHEMA | VARCHAR(128) | No | Name of the schema to which the data type of this geocoder output parameter belongs. This name is obtained from the Db2® catalog. |
| RETURN_TYPE_NAME | VARCHAR(128) | No | Unqualified name of the data type of this geocoder output parameter. This name is obtained from the Db2 catalog. |
| VENDOR | VARCHAR(256) | Yes | Name of the vendor that created this geocoder. |
| DESCRIPTION | VARCHAR(256) | Yes | Description of the geocoder that indicates its application. |