unregister_spatial_column

Use the unregister_spatial_column command to remove the registration of a spatial column.

This command removes the registration by:
  • Removing association of the spatial reference system with the spatial column. The DB2GSE.ST_GEOMETRY_COLUMNS catalog view continues to contain the spatial column, but the column is no longer associated with any spatial reference system.
  • For a base table, dropping the triggers that IBM® Spatial Support for Db2 for z/OS® placed on this table to ensure that the geometry values in this spatial column are all represented in the same spatial reference system.
Note: If you drop the table that contains the spatial column before unregistering the spatial column, the triggers are still dropped. However, the entry for the spatial column will still exist in the DB2GSE.ST_GEOMETRY_COLUMNS catalog view. You must still run the unregister_spatial_column command to remove the entry for the spatial column.

Authorization

The user ID under which this command is invoked must hold one of the following authorities or privileges:
  • SYSADM or DBADM authority
  • All table or view privileges on this table

Command syntax

DSN5SCLP /unregister_spatial_column DALLAS
	[-tableSchema schema]
	-tableName table_name
	-columnName column_name

Parameter descriptions

All parameters are required and case-sensitive unless otherwise indicated.

-tableSchema
Identifies the schema to which the table that is specified in the -tableName parameter belongs. This parameter is optional.

If this parameter is not specified, the value in the CURRENT SCHEMA special register is used as the schema name for the table or view.

-tableName
Identifies the unqualified name of the table that contains the column that is specified in the -columnName parameter. You must specify a non-empty value for this parameter.

-columnName
Identifies the spatial column that you want to unregister. You must specify a non-empty value for this parameter.

Example

This example shows the unregister_spatial_column command with all of the parameters specified.
DSN5SCLP /unregister_spatial_column DALLAS +
-tableSchema DB2GSE -tableName TABLE2 -columnName SPATIALCOL +