drop_srs

Use the drop_srs command to drop a spatial reference system.

When this command is processed, information about the spatial reference system is removed from the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.

Restriction: You cannot drop a spatial reference system if a spatial column that uses that spatial reference system is registered.

Important: Use care when you use this command. If you use this command to drop a spatial reference system, and if any spatial data is associated with that spatial reference system, you can no longer perform spatial operations on the spatial data.

Authorization

The user ID under which the command is invoked must have either SYSADM or DBADM authority.

Command syntax

DSN5SCLP /drop_srs DALLAS
	-srsName srs_name

Parameter descriptions

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

-srsName: Uniquely identifies the name of the index to be dropped. You must specify a non-empty value for this parameter.

Example

This example shows how you can use the drop_srs command to drop the NEWSRS2006B spatial reference system.

DSN5SCLP /drop_srs DALLAS +
-srsName NEWSRS2006B