JBoss.orgCommunity Documentation

Teiid - Scalable Information Integration

Teiid Reference Documentation

6.0.0

Copyright © 2008 Red Hat, Inc.

Legal Notice
Preface
1. SQL 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. Temp Tables
1.6. SQL Clauses
1.6.1. SELECT Clause
1.6.2. FROM Clause
1.6.3. WHERE Clause
1.6.4. GROUP BY Clause
1.6.5. HAVING Clause
1.6.6. ORDER BY Clause
1.6.7. LIMIT Clause
1.6.8. INTO Clause
1.6.9. OPTION Clause
1.7. Set Operations
1.8. Subqueries
1.8.1. Inline views
1.8.2. Subqueries in the WHERE and HAVING clauses
2. XML SELECT Command
2.1. Overview
2.2. Query Structure
2.2.1. FROM Clause
2.2.2. SELECT Clause
2.2.3. WHERE Clause
2.2.4. ORDER BY Clause
2.3. Document Generation
2.3.1. Document Validation
3. Datatypes
3.1. Supported Types
3.2. Type Conversions
3.3. Special Conversion Cases
3.3.1. Conversion of String Literals
3.3.2. Converting to Boolean
3.3.3. Date/Time/Timestamp Type Conversions
3.4. Escaped Literal Syntax
4. Scalar Functions
4.1. Numeric Functions
4.1.1. Parsing Numeric Datatypes from Strings
4.1.2. Formatting Numeric Datatypes as Strings
4.2. String Functions
4.3. Date/Time Functions
4.3.1. Parsing Date Datatypes from Strings
4.3.2. Specifying Time Zones
4.4. Type Conversion Functions
4.5. Choice Functions
4.6. Decode Functions
4.7. Lookup Function
4.7.1. Clearing the Cache
4.8. System Functions
4.9. XML Functions
4.10. Security Functions
4.11. User Defined Functions
4.11.1. UDF Definition
4.11.2. Source Supported UDF
4.11.3. Non-pushdown Support for User-Defined Functions
4.11.4. Installing user-defined functions
5. Procedures
5.1. Procedure Language
5.1.1. Command Statement
5.1.2. Dynamic SQL Command
5.1.3. Declaration Statement
5.1.4. Assignment Statement
5.1.5. If Statement
5.1.6. Loop Statement
5.1.7. While Statement
5.1.8. Continue Statement
5.1.9. Break Statement
5.1.10. Error Statement
5.2. Virtual Procedures
5.2.1. Virtual Procedure Definition
5.2.2. Procedure Input Parameters
5.2.3. Examle Virtual Procedures
5.2.4. Executing Virtual Procedures
5.3. Update Procedures
5.3.1. Update Procedure Definition
5.3.2. Special Variables
5.3.3. Update Procedure Command Criteria
5.3.4. Update Procedure Processing
6. Transaction Support
6.1. AutoWrap Execution Property
6.2. Updating Model Count
6.3. JDBC and Transactions
6.3.1. JDBC API Functionality
6.3.2. J2EE Usage Models
6.4. Limitations and Workarounds
7. System Tables
7.1. VDB and Model Metadata
7.1.1. System.VirtualDatabases
7.1.2. System.Models
7.1.3. System.ModelProperties
7.2. Table Metadata
7.2.1. System.Groups
7.2.2. System.GroupProperties
7.2.3. System.Elements
7.2.4. System.ElementProperties
7.2.5. System.Keys
7.2.6. System.KeyProperties
7.2.7. System.KeyElements
7.3. Procedure Metadata
7.3.1. System.Procedures
7.3.2. System.ProcedureProperties
7.3.3. System.ProcedureParams
7.4. Datatype Metadata
7.4.1. System.DataTypes
7.4.2. System.DataTypeProperties
8. Connectors
8.1. Common Connector Properties
8.2. Source Security
8.2.1. Specific Source Credentials
8.2.2. Using Session Credentials
8.2.3. Session and Specific Source Credentials
8.2.4. Configuring Connectors For Source Security
9. Federated Planning
9.1. Overview
9.2. Federated Optimizations
9.2.1. Access Patterns
9.2.2. Pushdown
9.2.3. Dependent Joins
9.2.4. Copy Criteria
9.2.5. Projection Minimization
9.2.6. Partial Aggregate Pushdown
9.2.7. Optional Join
9.2.8. Standard Relational Techniques
9.3. Federated Failure Modes
9.3.1. Partial Results
9.4. Query Plans
9.4.1. Getting a Query Plan
9.4.2. Analyzing a Query Plan
9.4.3. Relational Plans
9.5. Query Planner
9.5.1. Relational Planner
9.5.2. Procedure Planner
9.5.3. XML Planner
9.5.4. XQuery Planner
10. Architecture
10.1. Terminology
10.2. Data Management
10.2.1. Cursoring and Batching
10.2.2. Buffer Management
10.2.3. Cleanup
10.3. Query Termination
10.3.1. Canceling Queries
10.3.2. Timeouts
10.4. Processing
10.4.1. Join Algorithms
10.4.2. Sort Based Algorithms
A. BNF Grammar
A.1. Terminals
A.2. Non-Terminals