db2se remove_gc_setup command

The db2se remove_gc_setup command removes all the geocoding setup information for a geocoded column.

The information that is associated with the specified geocoded column is no longer available from the DB2GSE.ST_GEOCODING and DB2GSE.ST_GEOCODING_PARAMETERS catalog views.

Authorization

The user ID must hold one of the following authorities or privileges to run this command:

DATAACCESS authority on the database that contains the table on which the specified geocoder is to operate
CONTROL privilege on this table
UPDATE privilege on this table

Command syntax

db2se remove_gc_setup command

Command parameters

Where:

database_name: Specifies the name of the database for which you want to remove all the geocoding setup information for a geocoded column.
-userId user_id: Specifies the database user ID that has DATAACCESS authority on the database indicated by database_name.
-pw password: Specifies the password for user_id.
-tableSchema table_schema: Specifies the schema name for the specified table_name. If you do not specify a schema name, the value in the CURRENT SCHEMA special register is used as the schema name for the table or view.
-tableName table_name: Specifies the unqualified name of the table for the specified column_name. The table_name value is converted to uppercase unless you enclose it in double quotation marks.
-columnName column_name: Identifies the column name from which you want to remove the geocoding setup. The column_name value is converted to uppercase unless you enclose it in double quotation marks.

Usage notes

You cannot remove a geocoding setup if autogeocoding is enabled for the geocoded column.

Examples

The following example removes a setup for geocoding operations that apply to a spatial column named MYCOLUMN in table MYTABLE.

db2se remove_gc_setup mydb -tableName mytable -columnName mycolumn