JBoss.orgCommunity Documentation

Teiid - Scalable Information Integration

Teiid Reference Documentation

7.7

Copyright © 2012 Red Hat, Inc.

Legal Notice
Preface
1. DML Support
1.1. Identifiers
1.1.1. Reserved Words
1.2. Expressions
1.2.1. Column Identifiers
1.2.2. Literals
1.2.3. Aggregate Functions
1.2.4. Window functions
1.2.5. Case and searched case
1.2.6. Scalar subqueries
1.2.7. 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. Set Operations
1.6. Subqueries
1.6.1. Inline views
1.6.2. Subqueries can appear anywhere where an expression or criteria is expected.
2. SQL Clauses
2.1. WITH Clause
2.2. SELECT Clause
2.3. FROM Clause
2.3.1. From Clause Hints
2.3.2. Nested Table Reference
2.3.3. TEXTTABLE
2.3.4. XMLTABLE
2.4. ARRAYTABLE
2.5. WHERE Clause
2.6. GROUP BY Clause
2.7. HAVING Clause
2.8. ORDER BY Clause
2.9. LIMIT Clause
2.10. INTO Clause
2.11. OPTION Clause
3. DDL Support
3.1. Temp Tables
3.2. Alter View
3.3. Alter Procedure
3.4. Create Trigger
3.5. Alter Trigger
4. XML SELECT Command
4.1. Overview
4.2. Query Structure
4.2.1. FROM Clause
4.2.2. SELECT Clause
4.2.3. WHERE Clause
4.2.4. ORDER BY Clause
4.3. Document Generation
4.3.1. Document Validation
5. Datatypes
5.1. Supported Types
5.2. Type Conversions
5.3. Special Conversion Cases
5.3.1. Conversion of String Literals
5.3.2. Converting to Boolean
5.3.3. Date/Time/Timestamp Type Conversions
5.4. Escaped Literal Syntax
6. Scalar Functions
6.1. Numeric Functions
6.1.1. Parsing Numeric Datatypes from Strings
6.1.2. Formatting Numeric Datatypes as Strings
6.2. String Functions
6.3. Date/Time Functions
6.3.1. Parsing Date Datatypes from Strings
6.3.2. Specifying Time Zones
6.4. Type Conversion Functions
6.5. Choice Functions
6.6. Decode Functions
6.7. Lookup Function
6.8. System Functions
6.8.1. COMMANDPAYLOAD
6.8.2. ENV
6.8.3. SESSION_ID
6.8.4. USER
6.8.5. CURRENT_DATABASE
6.9. XML Functions
6.9.1. JSONTOXML
6.9.2. XMLCOMMENT
6.9.3. XMLCONCAT
6.9.4. XMLELEMENT
6.9.5. XMLFOREST
6.9.6. XMLPARSE
6.9.7. XMLPI
6.9.8. XMLQUERY
6.9.9. XMLSERIALIZE
6.9.10. XSLTRANSFORM
6.9.11. XPATHVALUE
6.10. Security Functions
6.10.1. HASROLE
6.11. Miscellaneous Functions
6.11.1. array_get
6.11.2. array_length
6.11.3. uuid
6.12. Nondeterministic Function Handling
7. Updatable Views
7.1. Key-preserved Table
8. Procedures
8.1. Procedure Language
8.1.1. Command Statement
8.1.2. Dynamic SQL Command
8.1.3. Declaration Statement
8.1.4. Assignment Statement
8.1.5. Compound Statement
8.1.6. If Statement
8.1.7. Loop Statement
8.1.8. While Statement
8.1.9. Continue Statement
8.1.10. Break Statement
8.1.11. Leave Statement
8.1.12. Error Statement
8.2. Virtual Procedures
8.2.1. Virtual Procedure Definition
8.2.2. Procedure Parameters
8.2.3. Example Virtual Procedures
8.2.4. Executing Virtual Procedures
8.2.5. Limitations
8.3. Update Procedures
8.3.1. Update Procedure Processing
8.3.2. For Each Row
8.3.3. Create Procedure
9. Transaction Support
9.1. AutoCommitTxn Execution Property
9.2. Updating Model Count
9.3. JDBC and Transactions
9.3.1. JDBC API Functionality
9.3.2. J2EE Usage Models
9.4. Transactional Behavior with JBoss Data Source Types
9.5. Limitations and Workarounds
10. Data Roles
10.1. Permissions
10.2. Role Mapping
10.3. XML Definition
10.4. System Functions
10.5. Customizing
11. System Schema
11.1. System Tables
11.1.1. VDB, Schema, and Properties
11.1.2. Table Metadata
11.1.3. Procedure Metadata
11.1.4. Datatype Metadata
11.2. System Procedures
11.2.1. SYS.getXMLSchemas
11.2.2. SYSADMIN.logMsg
11.2.3. SYSADMIN.isLoggable
11.2.4. SYSADMIN.refreshMatView
11.2.5. SYSADMIN.refreshMatViewRow
11.2.6. Metadata Procedures
12. VDBs
12.1. VDB Definition
12.1.1. VDB Element
12.1.2. Model Element
12.1.3. Translator Element
12.2. Dynamic VDBs
12.3. Multi-Source Models and VDB
12.3.1. Multi-source SELECTs
12.3.2. Multi-source INSERTs
12.3.3. Multi-source UPDATEs
12.3.4. Multi-source DELETEs
12.3.5. Multi-source Stored Procedures
12.3.6. Additional Concerns
13. Translators
13.1. Introduction to the Teiid Connector Architecture
13.2. Translators
13.2.1. File Translator
13.2.2. JDBC Translator
13.2.3. LDAP Translator
13.2.4. Loopback Translator
13.2.5. Salesforce Translator
13.2.6. Web Services Translator
13.2.7. OLAP Translator
13.2.8. Delegating Translators
14. Federated Planning
14.1. Overview
14.2. Federated Optimizations
14.2.1. Access Patterns
14.2.2. Pushdown
14.2.3. Dependent Joins
14.2.4. Copy Criteria
14.2.5. Projection Minimization
14.2.6. Partial Aggregate Pushdown
14.2.7. Optional Join
14.2.8. Partitioned Union
14.2.9. Standard Relational Techniques
14.3. Subquery optimization
14.4. XQuery Optimization
14.5. Federated Failure Modes
14.5.1. Partial Results
14.6. Query Plans
14.6.1. Getting a Query Plan
14.6.2. Analyzing a Query Plan
14.6.3. Relational Plans
14.6.4. Source Hints
14.7. Query Planner
14.7.1. Relational Planner
14.7.2. Procedure Planner
14.7.3. XML Planner
15. Architecture
15.1. Terminology
15.2. Data Management
15.2.1. Cursoring and Batching
15.2.2. Buffer Management
15.2.3. Cleanup
15.3. Query Termination
15.3.1. Canceling Queries
15.3.2. User Query Timeouts
15.4. Processing
15.4.1. Join Algorithms
15.4.2. Sort Based Algorithms
A. BNF for SQL Grammar
A.1. TOKENS
A.2. NON-TERMINALS