h1. *JDBC ANSI Translator* (jdbc-ansi) |
{space-metadata-from:jdbcParent} |
The JDBC ANSI translator, known by the type name *_jdbc-ansi_*, declares support for most SQL constructs supported by Teiid, except for row limit/offset and EXCEPT/INTERSECT. Translates source SQL into ANSI compliant syntax. This translator should be used when another more specific type is not available. If source exceptions arise from unsupported SQL, then consider using the [JDBC Simple Translator] to further restrict capabilities, or create a [Custom Translator|Translator Development] / create an enhancement request. |
Also see common JDBC Translator Information
The JDBC ANSI translator, known by the type name jdbc-ansi, declares support for most SQL constructs supported by Teiid, except for row limit/offset and EXCEPT/INTERSECT. Translates source SQL into ANSI compliant syntax. This translator should be used when another more specific type is not available. If source exceptions arise from unsupported SQL, then consider using the JDBC Simple Translator to further restrict capabilities, or create a Custom Translator / create an enhancement request.