JBoss.orgCommunity Documentation

Teiid - Scalable Information Integration

Teiid Reference Documentation

7.4

Copyright © 2011 Red Hat, Inc.

Legal Notice
Preface
1. DML Support
1.1. Identifiers
1.2. Expressions
1.2.1. Column Identifiers
1.2.2. Literals
1.2.3. Aggregate Functions
1.2.4. Case and searched case
1.2.5. Scalar subqueries
1.2.6. Parameter references
1.3. Criteria
1.4. SQL Commands
1.4.1. SELECT Command
1.4.2. INSERT Command
1.4.3. UPDATE Command
1.4.4. DELETE Command
1.4.5. EXECUTE Command
1.4.6. Procedural Relational Command
1.5. SQL Clauses
1.5.1. WITH Clause
1.5.2. SELECT Clause
1.5.3. FROM Clause
1.5.4. ARRAYTABLE
1.5.5. WHERE Clause
1.5.6. GROUP BY Clause
1.5.7. HAVING Clause
1.5.8. ORDER BY Clause
1.5.9. LIMIT Clause
1.5.10. INTO Clause
1.5.11. OPTION Clause
1.6. Set Operations
1.7. Subqueries
1.7.1. Inline views
1.7.2. Subqueries can appear anywhere where an expression or criteria is expected.
2. DDL Support
2.1. Temp Tables
2.2. Alter View
2.3. Alter Procedure
2.4. Create Trigger
2.5. Alter Trigger
3. XML SELECT Command
3.1. Overview
3.2. Query Structure
3.2.1. FROM Clause
3.2.2. SELECT Clause
3.2.3. WHERE Clause
3.2.4. ORDER BY Clause
3.3. Document Generation
3.3.1. Document Validation
4. Datatypes
4.1. Supported Types
4.2. Type Conversions
4.3. Special Conversion Cases
4.3.1. Conversion of String Literals
4.3.2. Converting to Boolean
4.3.3. Date/Time/Timestamp Type Conversions
4.4. Escaped Literal Syntax
5. Scalar Functions
5.1. Numeric Functions
5.1.1. Parsing Numeric Datatypes from Strings
5.1.2. Formatting Numeric Datatypes as Strings
5.2. String Functions
5.3. Date/Time Functions
5.3.1. Parsing Date Datatypes from Strings
5.3.2. Specifying Time Zones
5.4. Type Conversion Functions
5.5. Choice Functions
5.6. Decode Functions
5.7. Lookup Function
5.8. System Functions
5.9. XML Functions
5.9.1. JSONTOXML
5.9.2. XMLCOMMENT
5.9.3. XMLCONCAT
5.9.4. XMLELEMENT
5.9.5. XMLFOREST
5.9.6. XMLPARSE
5.9.7. XMLPI
5.9.8. XMLQUERY
5.9.9. XMLSERIALIZE
5.9.10. XSLTRANSFORM
5.9.11. XPATHVALUE
5.10. Security Functions
5.10.1. HASROLE
5.11. Miscellaneous Functions
5.11.1. array_get
5.11.2. array_length
5.11.3. uuid
5.12. Nondeterministic Function Handling
6. Updatable Views
6.1. Key-preserved Table
7. Procedures
7.1. Procedure Language
7.1.1. Command Statement
7.1.2. Dynamic SQL Command
7.1.3. Declaration Statement
7.1.4. Assignment Statement
7.1.5. If Statement
7.1.6. Loop Statement
7.1.7. While Statement
7.1.8. Continue Statement
7.1.9. Break Statement
7.1.10. Error Statement
7.2. Virtual Procedures
7.2.1. Virtual Procedure Definition
7.2.2. Procedure Parameters
7.2.3. Example Virtual Procedures
7.2.4. Executing Virtual Procedures
7.2.5. Limitations
7.3. Update Procedures
7.3.1. Update Procedure Processing
7.3.2. For Each Row
7.3.3. Create Procedure
8. Transaction Support
8.1. AutoCommitTxn Execution Property
8.2. Updating Model Count
8.3. JDBC and Transactions
8.3.1. JDBC API Functionality
8.3.2. J2EE Usage Models
8.4. Transactional Behavior with JBoss Data Source Types
8.5. Limitations and Workarounds
9. Data Roles
9.1. Permissions
9.2. Role Mapping
9.3. XML Definition
9.4. System Functions
10. System Schema
10.1. System Tables
10.1.1. VDB, Schema, and Properties
10.1.2. Table Metadata
10.1.3. Procedure Metadata
10.1.4. Datatype Metadata
10.2. System Procedures
10.2.1. SYS.getXMLSchemas
10.2.2. SYSADMIN.refreshMatView
10.2.3. SYSADMIN.refreshMatViewRow
10.2.4. Metadata Procedures
11. Multi-source models
11.1. Multi-source SELECTs
11.2. Multi-source INSERTs
11.3. Multi-source UPDATEs
11.4. Multi-source DELETEs
11.5. Multi-source Stored Procedures
11.6. Additional Concerns
12. Translators
12.1. Introduction to the Teiid Connector Architecture
12.2. Translators
12.2.1. File Translator
12.2.2. JDBC Translator
12.2.3. LDAP Translator
12.2.4. Loopback Translator
12.2.5. Salesforce Translator
12.2.6. Web Services Translator
12.2.7. OLAP Translator
12.2.8. Delegating Translators
12.3. Dynamic VDBs
12.3.1. VDB Element
12.3.2. Model Element
12.3.3. Translator Element
12.4. Multi-Source Models and VDB
13. Federated Planning
13.1. Overview
13.2. Federated Optimizations
13.2.1. Access Patterns
13.2.2. Pushdown
13.2.3. Dependent Joins
13.2.4. Copy Criteria
13.2.5. Projection Minimization
13.2.6. Partial Aggregate Pushdown
13.2.7. Optional Join
13.2.8. Partitioned Union
13.2.9. Standard Relational Techniques
13.3. Subquery optimization
13.4. Federated Failure Modes
13.4.1. Partial Results
13.5. Query Plans
13.5.1. Getting a Query Plan
13.5.2. Analyzing a Query Plan
13.5.3. Relational Plans
13.6. Query Planner
13.6.1. Relational Planner
13.6.2. Procedure Planner
13.6.3. XML Planner
14. Architecture
14.1. Terminology
14.2. Data Management
14.2.1. Cursoring and Batching
14.2.2. Buffer Management
14.2.3. Cleanup
14.3. Query Termination
14.3.1. Canceling Queries
14.3.2. Timeouts
14.4. Processing
14.4.1. Join Algorithms
14.4.2. Sort Based Algorithms
A. BNF for SQL Grammar
A.1. TOKENS
A.2. NON-TERMINALS