User's Guide and Reference

db2gse.gse_disable_autogc

Use this stored procedure to drop or temporarily disable triggers that keep a spatial column synchronized with its associated attribute column or columns. For example, it is advisable to disable the triggers while you geocode the values in the attribute column or columns in batch mode. For more on this, see About geocoding.

For an example of the code for invoking this stored procedure, see the C function gseDisableAutoGc in the sample program. For information about this program, see Writing applications for DB2 Spatial Extender.

Authorization

The user ID under which this stored procedure is invoked must have authorization in the form of an authority, privilege, or set of privileges; specifically:

SYSADM or DBADM authority on the database the contains the table on which the triggers that are being dropped or temporarily disabled are defined.
The CONTROL privilege on this table.
The ALTER, SELECT, and UPDATE privileges on this table.

Input parameters

Table 6. Input parameters for the db2gse.gse_disable_autogc stored procedure.

Name Data type Description
operMode SMALLINT Indicates whether the triggers are to be dropped or temporarily disabled.
This parameter is not nullable.
Comment: To drop triggers, use the GSE_AUTOGC_DROP macro. To temporarily disable them, use the GSE_AUTOGC_INVALIDATE macro. To find out what values are associated with these macros, consult the db2gse.h file. On AIX, this file is stored in the $DB2INSTANCE/sqllib/include/ directory. On Windows NT, it is stored in the %DB2PATH%\include\ directory.
layerSchema VARCHAR(30) Name of the schema to which the table or view 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_disable_autogc stored procedure is invoked.
layerTable VARCHAR(128) Name of the table on which the triggers you want dropped or temporarily disabled are defined.
This parameter is not nullable.
layerColumn VARCHAR(128) Name of the spatially-enabled column that is maintained by the triggers that you want dropped or temporarily disabled.
This parameter is not nullable.

Name	Data type	Description
operMode	SMALLINT	Indicates whether the triggers are to be dropped or temporarily disabled. This parameter is not nullable. Comment: To drop triggers, use the GSE_AUTOGC_DROP macro. To temporarily disable them, use the GSE_AUTOGC_INVALIDATE macro. To find out what values are associated with these macros, consult the db2gse.h file. On AIX, this file is stored in the $DB2INSTANCE/sqllib/include/ directory. On Windows NT, it is stored in the %DB2PATH%\include\ directory.
layerSchema	VARCHAR(30)	Name of the schema to which the table or view 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_disable_autogc stored procedure is invoked.
layerTable	VARCHAR(128)	Name of the table on which the triggers you want dropped or temporarily disabled are defined. This parameter is not nullable.
layerColumn	VARCHAR(128)	Name of the spatially-enabled column that is maintained by the triggers that you want dropped or temporarily disabled. This parameter is not nullable.

Output parameters

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

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.

[ Top of Page | Previous Page | Next Page ]