Loading spatial data from a Well Known Text (WKT) file

You can add spatial data to a table by using a Well Known Text file (WKT) that contains text that can be used to load spatial data into a database and be represented as geometry.

Prerequisites

The privileges required to load data depend on the -gl server option. If the -gl option is set to ALL, one of the following must be true:

you are the owner of the table
you have LOAD privilege on the table
you have the LOAD ANY TABLE system privilege
you have the ALTER ANY TABLE system privilege

If the -gl option is set to DBA, you must the LOAD ANY TABLE or ALTER ANY TABLE system privilege.

If the -gl option is set to NONE, LOAD TABLE is not permitted.

When loading from a file on a client computer:

READ CLIENT FILE privilege is also required.
Read privileges are required on the directory being read from.
The allow_read_client_file database option must be enabled.
The read_client_file secure feature must be enabled.

Task

Create a file that contains spatial data in WKT format that you can load into the database.

The file can be in any format supported by the LOAD TABLE statement.
In Interactive SQL, connect to your database.

Create a table and load the data from the file into using a statement similar to the following:

DROP TABLE IF EXISTS SA_WKT;
CREATE TABLE SA_WKT (
    description CHAR(24),
    sample_geometry ST_Geometry(SRID=1000004326)
);

LOAD TABLE SA_WKT FROM 'C:\\Documents and Settings\\All Users\\Documents\\SAP Sybase IQ 16\\Samples\\wktgeometries.csv' DELIMITED BY ',';

The data is loaded into the table.

The spatial data is successfully loaded from the WKT file.

Next

You can view the data in Interactive SQL using the Spatial Viewer.