Introduction
Legal Notice
Administrator’s Guide
Logging
Socket Transports
System Properties
Diagnosing Issues
Caching Guide
Results Caching
Materialized Views
Internal Materialization
Code Table Caching
Translator Results Caching
Hints and Options
Programmatic Control
Client Developer’s Guide
JDBC Support
Connecting to a Teiid Server
Driver Connection
SSL Client Connections
Additional Socket Client Settings
Prepared Statements
ResultSet Limitations
JDBC Extensions
Statement Extensions
Partial Results Mode
Non-blocking Statement Execution
ResultSet Extensions
Connection Extensions
Unsupported JDBC Methods
Unsupported Classes and Methods in "java.sql"
Unsupported Classes and Methods in "javax.sql"
ODBC Support
Configuring the Data Source Name (DSN)
DSN Less Connection
ODBC Connection Properties
OData Support
OData Version 4.0 Support
GeoServer Integration
QGIS Integration
SQLAlchemy Integration
Node.js Integration
ADO.NET Integration
Reauthentication
Execution Properties
SET Statement
SHOW Statement
Transactions
Local Transactions
Request Level Transactions
Using Global Transactions
Restrictions
Translator Development
Caching API
Command Language
Dependent Join Pushdown
Executing Commands
Large Objects
Translator Capabilities
Translator Properties
User Defined Functions
Source Supported Functions
Support for User-Defined Functions(Non-Pushdown)
Reference Guide
Release Notes
Virtual databases
DDL VDB
VDB properties
Schema object DDL
Domain DDL
SQL Support
Identifiers
Operator Precedence
Expressions
Column identifiers
Literals
Aggregate functions
Window functions
Case and searched case expressions
Scalar subqueries
Parameter references
Arrays
Criteria
Scalar functions
Numeric functions
String functions
Date_Time functions
Type conversion functions
Choice functions
Decode functions
Lookup function
System functions
XML functions
JSON functions
Security functions
Spatial functions
Miscellaneous functions
Nondeterministic function handling
DML commands
Set operations
SELECT command
VALUES command
Update commands
INSERT command
UPDATE command
DELETE
UPSERT/MERGE command
EXECUTE command
Procedural relational command
Anonymous procedure block
Subqueries
WITH clause
SELECT clause
FROM clause
Nested tables
XMLTABLE
ARRAYTABLE
OBJECTTABLE
TEXTTABLE
JSONTABLE
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
LIMIT clause
INTO clause
OPTION clause
DDL commands
Temporary tables
Local temporary tables
Global temporary tables
Global and local temporary table features
Foreign temporary tables
Alter view
Alter procedure
Alter trigger
Procedures
Procedure language
Command statement
Dynamic SQL command
Declaration statement
Assignment statement
Special variables
Compound statement
IF statement
LOOP statement
WHILE statement
CONTINUE statement
BREAK statement
LEAVE statement
RETURN statement
ERROR statement
RAISE statement
Exception-expression
Virtual procedures
Update procedures (Triggers)
Comments
Explain statement
Datatypes
Supported types
Type conversions
Special conversion cases
Escaped literal syntax
Updatable views
Key-preserved tables
Transactions
AutoCommitTxn execution property
Updating model count
JDBC and transactions
Limitations and workarounds
Data roles
Permissions
Role mapping
System schema
SYS schema
SYSADMIN schema
Translators
Amazon S3 translator
Cassandra translator
Delegator translators
Extending the delegator translator
File translator
Google spreadsheet translator
JDBC translators
Actian vector translator
Amazon Athena translator
Apache Phoenix translator
Cloudera Impala translator
Db2 translator
Derby translator
Exasol translator
Greenplum translator
H2 translator
Hive translator
HSQL translator
Informix translator
Ingres translators
Intersystems Cache translator
JDBC ANSI translator
JDBC Simple translator
Microsoft Access translators
Microsoft SQL Server translator
MySQL translators
Netezza translator
Oracle translator
PostgreSQL translator
PrestoDB translator
Redshift translator
SAP HANA translator
SAP IQ translator
Sybase translator
Teiid translator
Teradata translator
Vertica translator
Loopback translator
Microsoft Excel translator
MongoDB translator
Salesforce translators
REST translator
SOAP translator
Federated planning
Planning overview
Query planner
Query plans
Federated optimizations
Subquery optimization
XQuery optimization
Federated failure modes
Conformed tables
Architecture
Terminology
Data management
Query termination
Processing
BNF for SQL grammar
Published with GitBook
Parameter references
Parameter references
results matching "
"
No results matching "
"