Extensions.Sql
Jump to navigation
Jump to search
Contents
Classification
| Name | SQL |
| Short Description | Allows connections to a database and commands for manipulating the data within the database. |
| Class | OTX Extension |
| Base Extension | - |
| Pre-Conditions | - |
| Specified by | ISO 13209-4 |
Introduction
The purpose of the OTX SQL Extension is to provide simple actions and terms to handle an access to a OTX SQL Extension database. It allows connections to a database and OTX SQL Extension commands for manipulating the data within the database.
|
Important: The extension will be independent from a specific data provider. The selection of a specific data provider will covered by the tool specific runtime implementation. |
The types of OTX SQL Extension will be mapped to OTX and vice versa as described in the next table.
| SQL | OTX |
| integer | Integer |
| numeric, decimal | Float |
| float | Float |
| real | Float |
| double | FLoat |
| character, char | String |
| varchar | String |
| text | String |
| date | String |
| time | String |
| timestamp | String |
| boolean | Boolean |
| blod, clod | ByteField |
| other data types | not spec |
Actions
| CloseConnection | |
| ExecuteQuery | |
| ExecuteUpdate |
Terms
Data Types
| Connection | |
| ResultSet |
Exceptions
| CommandException | |
| ConnectionException | |
| SqlException |
Checker rules
| SQL_Chk001 | Right column data type |
