JBoss.orgCommunity Documentation

Teiid - Scalable Information Integration

Teiid Reference Documentation

7.2

Copyright © 2009 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. WITH Clause
1.6.2. SELECT Clause
1.6.3. FROM Clause
1.6.4. WHERE Clause
1.6.5. GROUP BY Clause
1.6.6. HAVING Clause
1.6.7. ORDER BY Clause
1.6.8. LIMIT Clause
1.6.9. INTO Clause
1.6.10. 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.8. System Functions
4.9. XML Functions
4.9.1. JSONTOXML
4.9.2. XMLCOMMENT
4.9.3. XMLCONCAT
4.9.4. XMLELEMENT
4.9.5. XMLFOREST
4.9.6. XMLPARSE
4.9.7. XMLPI
4.9.8. XMLQUERY
4.9.9. XMLSERIALIZE
4.9.10. XSLTRANSFORM
4.9.11. XPATHVALUE
4.10. Security Functions
4.10.1. HASROLE
4.11. Nondeterministic Function Handling
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. Example Virtual Procedures
5.2.4. Executing Virtual Procedures
5.2.5. Limitations
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. AutoCommitTxn 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. Transactional Behavior with JBoss Data Source Types
6.5. Limitations and Workarounds
7. Data Roles
7.1. Permissions
7.2. Role Mapping
7.3. XML Definition
7.4. System Functions
8. System Schema
8.1. System Tables
8.1.1. VDB, Schema, and Properties
8.1.2. Table Metadata
8.1.3. Procedure Metadata
8.1.4. Datatype Metadata
8.2. System Procedures
9. Translators
9.1. Introduction to the Teiid Connector Architecture
9.2. Translators
9.2.1. File Translator
9.2.2. JDBC Translator
9.2.3. LDAP Translator
9.2.4. Loopback Translator
9.2.5. Salesforce Translator
9.2.6. Web Services Translator
9.3. Dynamic VDBs
9.3.1. VDB Element
9.3.2. Model Element
9.3.3. Translator Element
9.4. Multi-Source Models and VDB
10. Federated Planning
10.1. Overview
10.2. Federated Optimizations
10.2.1. Access Patterns
10.2.2. Pushdown
10.2.3. Dependent Joins
10.2.4. Copy Criteria
10.2.5. Projection Minimization
10.2.6. Partial Aggregate Pushdown
10.2.7. Optional Join
10.2.8. Standard Relational Techniques
10.3. Federated Failure Modes
10.3.1. Partial Results
10.4. Query Plans
10.4.1. Getting a Query Plan
10.4.2. Analyzing a Query Plan
10.4.3. Relational Plans
10.5. Query Planner
10.5.1. Relational Planner
10.5.2. Procedure Planner
10.5.3. XML Planner
11. Architecture
11.1. Terminology
11.2. Data Management
11.2.1. Cursoring and Batching
11.2.2. Buffer Management
11.2.3. Cleanup
11.3. Query Termination
11.3.1. Canceling Queries
11.3.2. Timeouts
11.4. Processing
11.4.1. Join Algorithms
11.4.2. Sort Based Algorithms
A. BNF for SQL Grammar
A.1. TOKENS
A.2. NON-TERMINALS