User's Guide and Reference

db2gse.gse_import_shape

Use this stored procedure to import a shape file to a database that has been enabled for spatial operations. The stored procedure can operate in either of two ways:

• If the shape file is targeted for an existing table that has a registered layer column, DB2 Spatial Extender will load the table with the file's data.
• Otherwise, DB2 Spatial Extender will create a table that has a spatial column, register this column as a layer, and load the layer and the table's other columns with the file's data.

For an example of the code for invoking this stored procedure, see the C function gseImportShape 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 hold one of the following authorities or privileges:

• SYSADM or DBADM authority on the database that contains the table into which imported shape data is to be loaded.
• The CONTROL privilege on this table.

Input parameters

Table 22. Input parameters for the db2gse.gse_import_shape stored procedure.

Name	Data type	Description
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_import_shape stored procedure is invoked.
layerTable	VARCHAR(128)	Name of the table into which the imported shape file is to be loaded. This parameter is not nullable.
layerColumn	VARCHAR(30)	Name of the column that has been registered as the layer into which shape data is to be loaded. This parameter is not nullable.
fileName	VARCHAR(128)	Name of the shape file that is to be imported. This parameter is not nullable.
exceptionFile	VARCHAR(128)	Path and name of the file in which the shapes that could not be imported are stored. This is a new file that will be created when the db2gse.gse_import_shape stored procedure is run. This parameter is not nullable.
srId	INTEGER	Identifier of the spatial reference system to be used for the layer into which shape data is to be loaded. This parameter is nullable. Comment: If this identifier is not specified, the internal transformation will be set to the maximum resolution possible resolution for the shape file.
commitScope	INTEGER	Number of records per checkpoint. This parameter is nullable.

Output parameters

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