Supported and Unsupported SQL Statements

Reference:

SQL Translation Services is compliant with ANSI Level 2. This facility supports many, but not all, SQL statements. The Reporting Server and specific RDBMS engines may also support the alpha1 CONCAT alpha2 syntax. See Supported SQL Statements and Unsupported SQL Statements.

Many of the supported SQL statements are candidates for Dialect Translation. This feature enables a server to route inbound SQL requests to SQL-capable subservers and data adapters where possible. Dialect Translation avoids translation to the Reporting Server Data Manipulation Language (DML), while maintaining data location transparency. It transforms a standard SQL statement into one that can be processed by the destination SQL engine, while preserving the semantic meaning of the statement.

Note: Because the SQL Translator is ANSI Level 2 compliant, some requests that worked in prior releases may no longer work.


Top of page

x
Reference: Supported SQL Statements

SQL Translation Services supports the following:


Top of page

x
Reference: Unsupported SQL Statements

SQL Translation Services does not support the following:


Top of page

x
Reference: SQL Translator Reserved Words

The following words may not be used as field names in a Master File that is used with the SQL Translator:


WebFOCUS