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.SPATIAL_REF_SYS catalog view. For information about this view, see DB2GSE.SPATIAL_REF_SYS.
For an example of the code for invoking this stored procedure, see the C function gseDisableSref in the sample program. For information about this program, see Writing applications for DB2 Spatial Extender.
Authorization
None required.
Input parameter
Table 9. Input parameter for the db2gse.gse_disable_sref stored procedure.
| Name | Data type | Description |
|---|---|---|
| srId | INTEGER | Numeric identifier of the spatial reference system that is to be
dropped.
This parameter is not nullable. |
Output parameters
Table 10. Output parameters for the db2gse.gse_disable_sref stored procedure.
| Name | Data type | Description |
|---|---|---|
| msgCode | INTEGER | Code associated with the messages that the caller of this stored procedure can return. |
| Reserved | VARCHAR(1024) | Complete error message, as constructed at the DB2 Spatial Extender server. |
Restriction
Before you can drop a spatial reference system, you must unregister any layers that use it. If such layers remain unregistered, the request to drop the spatial reference system will be rejected.