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 Mapping
| 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
Terms
Data Types
Exceptions
Checker rules
