The options for Write Spatial Data depend on the type of operation you want to perform: Insert, Update by Filter, Update by Primary Key, Delete by Filter, or Delete by Primary Key.
Operation Tab
Option |
Description |
---|---|
Named table |
The name of the named table resource where you insert, update, or delete the spatial data. Initially, this field is empty. Click the Browse button to choose a writable table from the list of available tables in the repository. For instructions on creating a writable named table, see Creating Named Tables. If you select a non-writable named table, an error appears to the right of the field indicating that the named table is read-only and to select a writable table. In the case of an error in determining whether or not the table is writable, the table is deemed to be read-only and additional error information is shown. Named tables with composite primary keys are also considered to be read-only. Note: You must have View permissions on the named table as well as Create/Modify/Delete
permissions on the named table's associated dataset to perform insert, update, and
delete operations on writable tables. See Users and Roles in
the Administration section for more information.
Once you have selected the named table, the fields below the named table field will be populated. If the fields are not populated and you see a validation error ("You must include at least one data field to write to table") when attempting to save the stage, there may be a problem with the named connection details for the table. Open the spectrum-server.log to find the I/O exceptions. |
Delete existing records | This check box is available only for the Insert operation. Use it to delete all existing records in the table prior to Insert. |
WHERE | This field is available only for the Update by Filter or Delete by Filter operations. Type the contents of a MI SQL WHERE clause in this field to specify update or delete conditions, omitting the word WHERE. For example, enter STATE_NAME in ('New York', 'New Jersey') if you are using the STATES table. Click Verify to ensure that the WHERE clause works properly. See the MapInfo SQL Language Reference for detailed information on MI SQL commands and functions. Any column, including read-only and primary key columns, can be used in the WHERE clause. |
Include checkbox |
The Include checkbox allows you to select the table columns to be inserted, updated, or deleted; at least one must be selected. |
Table columns | The column names from the selected named table (these cannot be changed). The following rules are supported for all data providers: Insert
Update by Filter and Delete by Filter
Update by Primary Key and Delete by Primary Key
|
Type | The Type column returns the data type for the columns in the named table (these cannot be changed). |
Runtime Tab
Option |
Description |
---|---|
Batch size |
The number of inserts, updates, or deletes that will be processed in a transaction, where each feature (row) is considered a single insert, update, or delete. The default is 100. |
Supported Data Types
Type |
Description |
---|---|
boolean |
A logical type with two values: true and false |
double |
A numeric data type that contains both negative and positive double precision numbers between 2-1074 and (2-2-52)×21023. In E notation, the range of values double is 4.9E-324 to 1.7976931348623157E308 |
float |
A numeric data type that contains both negative and positive single precision numbers between 2-149 and (2-223)×2127. In E notation, the range of values is 1.4E-45 to 3.4028235E38 |
integer |
A numeric data type that contains both negative and positive whole numbers between -231 (-2,147,483,648) and 231-1 (2,147,483,647) |
long |
A numeric data type that contains both negative and positive whole numbers between -263 (-9,223,372,036,854,775,808) and 263-1(9,223,372,036,854,775,807) |
string |
A sequence of characters |
list |
When a field contains hierarchical data, it is treated as a "list" field. In Spectrum a list is a collection of data consisting of multiple values. For example, a field Names may contain a list of name values. This may be represented in an XML structure as a list of NAME elements wrapped in a NAMES element. It is important to note that the Spectrum list data type is different from the XML schema list data type in that the XML list data type is a simple data type consisting of multiple values, whereas the Spectrum list data type is similar to an XML complex data type |
geometry |
A data type representing a spatial entity (for example, point or polygon) |
bytearray | An array (list) of bytes |