Use this stored procedure to register a geocoder other than the default. To find out whether a geocoder has already been registered, consult the DB2GSE.SPATIAL_GEOCODER catalog view (described in DB2GSE.SPATIAL_GEOCODER).
Authorization
The user ID under which this stored procedure is invoked must hold either SYSADM or DBADM authority on the database that contains the geocoder that this stored procedure registers.
Input parameters
Table 24. Input parameters for the db2gse.gse_register_gc stored procedure.
| Name | Data type | Description |
|---|---|---|
| gcId | INTEGER | Numeric identifier of the geocoder that you are registering.
This parameter is not nullable. Comment: This identifier must be unique within the database. |
| gcName | VARCHAR(64) | Short description of the gecoder that you are registering.
This parameter is not nullable. Comment: This description must be a unique character string within the database. |
| vendorName | VARCHAR(64) | Name of vendor that supplied the geocoder that you are
registering.
This parameter is not nullable. |
| primaryUDF | VARCHAR(256) | Fully-qualified name of the geocoder that you are registering.
This parameter is not nullable. |
| precisionLevel | INTEGER | The degree to which source data must match corresponding reference data
in order for the geocoder to process the source data successfully.
This parameter is not nullable. Comment: The precision level can range from 1 to 100 percent. |
| vendorSpecific | VARCHAR(256) | Technical information provided by the vendor; for example, the path
and name of a file that the vendor uses to set parameters.
This parameter is nullable. |
| geoArea | VARCHAR(256) | Geographical area to be geocoded.
This parameter is nullable. |
| description | VARCHAR(256) | Remarks provided by the vendor
This parameter is nullable. |
Output parameters
Table 25. Output parameters for the db2gse.gse_register_gc stored procedure.
| Name | Data type | Description |
|---|---|---|
| msgCode | INTEGER | Code associated with the messages that the caller of this stored procedure can return. |
| Reserved | VARCHAR(1024) | Complete error message, as constructed at the DB2 Spatial Extender server. |