ST_DISABLE_AUTOGEOCODING procedure

Use this stored procedure to specify that Db2® Spatial Extender is to stop synchronizing a geocoded column with its associated geocoding column or columns.

A geocoding column is used as input to the geocoder.

Authorization

The user ID under which this stored procedure is invoked must have one of the following authorities or privileges:

DBADM and DATAACCESS authority on the database that contains the table on which the triggers that are being dropped are defined
CONTROL privilege on this table
ALTER and UPDATE privileges on this table

Note: For CONTROL and ALTER privileges, you must have DROPIN authority on the DB2GSE schema.

Syntax

Parameter descriptions

table_schema

Names the schema to which the table or view that is specified in the table_name parameter belongs. Although you must specify a value for this parameter, the value can be null. If this parameter is null, the value in the CURRENT SCHEMA special register is used as the schema name for the table or view.

The table_schema value is converted to uppercase unless you enclose it in quotation marks.

The data type for this parameter is VARCHAR(128) or, if you enclose the value in double quotation marks, VARCHAR(130).

table_name

Specifies the unqualified name of the table on which the triggers that you want dropped are defined. You must specify a non-null value for this parameter.

The table_name value is converted to uppercase unless you enclose it in double quotation marks.

The data type for this parameter is VARCHAR(128) or, if you enclose the value in double quotation marks, VARCHAR(130).

column_name

Names the geocoded column that is maintained by the triggers that you want dropped. You must specify a non-null value for this parameter.

The column_name value is converted to uppercase unless you enclose it in double quotation marks.

The data type for this parameter is VARCHAR(128) or, if you enclose the value in double quotation marks, VARCHAR(130).

Output parameters

msg_code: Specifies the message code that is returned from the stored procedure. The value of this output parameter identifies the error, success, or warning condition that was encountered during the processing of the procedure. If this parameter value is for a success or warning condition, the procedure finished its task. If the parameter value is for an error condition, no changes to the database were performed.
The data type of this output parameter is INTEGER.
msg_text: Specifies the actual message text, associated with the message code, that is returned from the stored procedure. The message text can include additional information about the success, warning, or error condition, such as where an error was encountered.
The data type of this output parameter is VARCHAR(1024).

Example

This example shows how to use the Db2 command line processor to invoke the ST_DISABLE_AUTOGEOCODING stored procedure. This example uses a Db2 CALL command to disable autogeocoding on the LOCATION column in the table named CUSTOMERS:


call DB2GSE.ST_DISABLE_AUTOGEOCODING(NULL,'CUSTOMERS','LOCATION',?,?)

The two question marks at the end of this CALL command represent the output parameters, msg_code and msg_text. The values for these output parameters are displayed after the stored procedure runs.