db2se drop_cs command

The db2se drop_cs command deletes a coordinate system definition.

This command deletes information about a coordinate system from the database. The information is no longer be available through the DB2GSE.ST_COORDINATE_SYSTEMS catalog view.

Authorization

The user ID must have DBADM and DATAACCESS authority on the spatially enabled database to run this command.

Command syntax

db2se drop_cs command

Read syntax diagramSkip visual syntax diagramdrop_csdatabase_name-userIduser_id-pwpassword -coordsysNamecoordsys_name

Command parameters

Where:
database_name
Specifies the name of the database for which you want to delete the coordinate system.
-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 the specified user_id.
-coordsysName coordsys_name
Uniquely identifies the coordinate system that you want to delete.

The coordsys_name value is converted to uppercase unless you enclose it in double quotation marks. The maximum length for this parameter is 128.

Usage notes

You cannot drop a coordinate system on which a spatial reference system is based.

Examples

The following example drops a coordinate system called MYCOORDSYS.

db2se drop_cs mydb -coordsysName mycoordsys