DB2GSE.ST_GEOCODING_PARAMETERS catalog view
When you set up geocoding operations for a particular geocoder, use the DB2GSE.ST_GEOCODING_PARAMETERS catalog view to obtain information about the geocoder-specific settings.
For example, an operation can be comparing addresses given as input to reference data.
When you set up operations for a geocoder, you specify what the degree, called the minimum match score, should be; and your specification is recorded in the catalog.
To find out the geocoder-specific aspects of a settings for geocoding operations, query the DB2GSE.ST_GEOCODING_PARAMETERS catalog view. This view is described in the following table.
| Name | Data type | Nullable? | Content |
|---|---|---|---|
| TABLE_SCHEMA | VARCHAR(128) | No | Name of the schema that contains the table that contains the column identified in the COLUMN_NAME column. |
| TABLE_NAME | VARCHAR(128) | No | Unqualified name of the table that contains the spatial column. |
| COLUMN_NAME | VARCHAR(128) | No | Name of the spatial column to be populated according
to the specifications shown in this catalog view. The combined values in the TABLE_SCHEMA, TABLE_NAME, and COLUMN_NAME columns uniquely identify this spatial column. |
| ORDINAL | SMALLINT | No | Position of this parameter (that is, the parameter
specified in the PARAMETER_NAME column) in the signature of the function
that serves as the geocoder for the column identified in the COLUMN_NAME
column. A record in the SYSCAT.ROUTINEPARMS catalog view also contains information about this parameter. This record contains a value that appears in the ORDINAL column of SYSCAT.ROUTINEPARMS. This value is the same one that appears in the ORDINAL column of the DB2GSE.ST_GEOCODING_PARAMETERS view. |
| PARAMETER_NAME | VARCHAR(128) | Yes | Name of a parameter in the definition of the geocoder. If no name was specified
when the geocoder was defined, PARAMETER_NAME is null. This content of the PARAMETER_NAME column is obtained from the Db2® catalog. |
| PARAMETER_VALUE | VARCHAR(2048) | Yes | The value that is assigned to this parameter. Db2 will interpret this
value as an SQL expression. If the value is enclosed in quotation marks, it will be passed to the
geocoder as a string. Otherwise, the evaluation of the SQL expression will determine what the
parameter's data type will be when it is passed to the geocoder. If the PARAMETER_VALUE column
contains a null, then this null is passed to the geocoder. The PARAMETER_VALUE column corresponds to the PARAMETER_DEFAULT column in the DB2GSE.ST_GEOCODER_PARAMETERS catalog view. If the PARAMETER_VALUE column contains a value, this value overrides the default value in the PARAMETER_DEFAULT column. If the PARAMETER_VALUE column is null, the default value will be used. |