User's Guide and Reference

db2gse.gse_unregist_layer

Use this stored procedure to unregister a layer. The stored procedure does this by:

• Removing the definition of the layer from DB2 Spatial Extender catalog tables.
• Deleting the check constraint that DB2 Spatial Extender placed on this layer's base table to ensure that the layer's spatial data conforms to the requirements of the layer's spatial reference system.
• Dropping the triggers that are used to update the spatial column whenever address data is added, changed, or removed.

When the stored procedure is processed, information about the layer is removed from the DB2GSE.GEOMETRY_COLUMNS meta view. For information about this view, see DB2GSE.GEOMETRY_COLUMNS.

Authorization

The user ID under which this stored procedure is invoked must hold one of the following authorities or privileges:

• For a table layer:
  • SYSADM or DBADM authority on the database that contains this layer's base table.
  • The CONTROL or ALTER privilege on this table.
• For a view layer:
  • The SELECT privilege on the base table or tables that contain (1) the address data that is geocoded for this layer and (2) the spatial data that results from the geocoding.

Input parameters

Table 32. Input parameters for the db2gse.gse_unregist_layer stored procedure.

Name	Data type	Description
layerSchema	VARCHAR(30)	Name of the schema to which the table specified in the layerTable parameter belongs. This parameter is nullable. Comment: If you do not supply a value for the layerSchema parameter, it will default to the user ID under which the db2gse.gse_unregister_layer stored procedure is invoked.
layerTable	VARCHAR(128)	Name of the table that contains the column specified in the layerColumn parameter. This parameter is not nullable.
layerColumn	VARCHAR(128)	Name of the spatial column that has been defined as the layer that you want to unregister. This parameter is not nullable.

Output parameters

Table 33. Output parameters for the db2gse.gse_unregist_layer 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

If a view column that has been defined as a view layer is based on a table column that has been defined as a table layer, you cannot unregister this table layer until you unregister the view layer.