SQL Translation Services

SQL Translation Services is the core component of a server. Using a feature called Automatic Passthru, the server initiates one of two possible processes to translate SQL requests and generate internal SQL command streams:

• Dialect Translation converts inbound SQL statements to statements that can be processed by the target DBMS engine.
• Data Manipulation Language (DML) converts inbound SQL that is ineligible for Dialect Translation to the internal retrieval language, TABLE. A data adapter then converts this to the target DBMS engine's internal DML.

After one of these conversions is complete, the request is passed to a backend database access module for subsequent action. It is the responsibility of the backend module to interpret internal SQL text and to interact with individual DBMSs as required.

For more information on SQL Passthru and SQL Translation Services, see SQL Services.

The purpose of this manual is to define ISO SQL in precise terms. It contains no information about native RDBMSs or their language support. Every mention of SQL within the body of this document should be considered a reference to ISO SQL-the dialect of SQL implemented by SQL Translation Services.