ST_drop_srs
Use this stored procedure to drop a spatial reference system.
When this stored procedure 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 stored procedure. If you use this stored procedure
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 stored procedure is invoked must have either SYSADM or DBADM authority.
Syntax
Parameter descriptions
- srs_name
- Identifies the spatial reference system. You must specify a non-null
value for this parameter.
The srs_name value is converted to uppercase unless you enclose it in double quotation marks.
The data type of 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(4096).
When the message code that is returned is 0 (zero), the message text parameter is set to null.
Example
This example shows how to use the Db2 CALL statement to invoke the ST_drop_srs
stored procedure. This example uses a Db2 CALL
statement to delete a spatial reference system named SRSDEMO:
call sysproc.ST_drop_srs('SRSDEMO',?,?)