User's Guide and Reference

db2gse.gse_import_sde

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

• If the SDE transfer 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.

The spatial reference system specified in the SDE transfer file will be compared with the spatial reference systems that are registered to DB2 Spatial Extender. If the specified system matches a registered system, the negative and decimal values in the transfer data will, when loaded, be modified in the way prescribed by the registered system. If the specified system matches none of the registered systems, DB2 Spatial Extender will create a new spatial reference system to prescribe the modifications.

Authorization

When you import data to an existing table, 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 to which data is to be imported.
• The CONTROL privilege on this table.

When the table to which you want to import data must be created, 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 that is to be created.

Input parameters

Table 20. Input parameters for the db2gse.gse_import_sde 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_sde stored procedure is invoked.
layerTable	VARCHAR(128)	Name of the table into which the SDE transfer data 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 the SDE transfer file's spatial data is to be loaded. This parameter is not nullable.
fileName	VARCHAR(128)	Name of the SDE transfer file that is to be imported. This parameter is not nullable.
commitScope	INTEGER	Number of records per checkpoint. This parameter is nullable.

Output parameters

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