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