> XQuery and XQSE Developer’s Guide

XQuery and XQSE Developer’s Guide

     Previous  Next    Contents    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Introducing the AquaLogic Data Services Platform XQuery Engine

XML and XQuery

XQuery Use in AquaLogic Data Services Platform

Supported XQuery Specifications

Learning More About the XQuery Language

BEA’s XQuery Implementation

BEA XQuery Function Implementation

Function Overview

Access Control Functions

fn-bea:is-access-allowed

fn-bea:is-user-in-group

fn-bea:is-user-in-role

fn-bea:userid

Duration, Date, and Time Functions

fn-bea:date-from-dateTime

fn-bea:date-from-string-with-format

fn-bea:date-to-string-with-format

fn-bea:dateTime-from-string-with-format

fn-bea:dateTime-to-string-with-format

fn-bea:time-from-dateTime

fn-bea:time-from-string-with-format

fn-bea:time-to-string-with-format

Date and Time Patterns

Execution Control Functions

fn-bea:async

fn-bea:fence

fn-bea:timeout and fn-bea:timeout-with-label

fn-bea-timeout Signature

fn-bea-timeout-with-label Signature

Operational Details

fn-bea:fail-over, fn-bea:fail-over-with-label, fn-bea:fail-over-retry, and fn-bea:fail-over-retry-with-label

Usage Suggestions

Numeric Functions

fn-bea:format-number

fn-bea:decimal-round

fn-bea:decimal-truncate

Other Functions

fn-bea:get-property

fn-bea:inlinedXML

fn-bea:rename

QName Functions

fn-bea:QName-from-string

Sequence Functions

fn-bea:interleave

String Functions

fn-bea:match

fn-bea:sql-like

fn-bea:trim

fn-bea:trim-left

fn-bea:trim-right

fn-bea:pad-left

Pad Left Function Using Default Character (ASCII 32)

Pad Left Function with Specified Pad String

fn-bea:pad-right

Pad Right Function Using Default Character (ASCII 32)

Pad Right Function with Specified Pad String

Extended XQuery Data Model (XXDM) Functions

fn-bea:current-value

fn-bea:old-value

Unsupported XQuery Functions

Implementation-Specific Functions and Operators

BEA XQuery Language Implementation

XQuery Language Support (and Unsupported Features)

Extensions to the XQuery Language in the AquaLogic Data Services Platform XQuery Engine

Generalized FLWGOR (group by)

Optional Indicator in Direct Element and Attribute Constructors

Implementation-Defined Values for XQuery Language Processing

XQuery Engine and SQL

Introduction

Base and Core RDBMS Support

How the XQuery Engine Supports SQL Data Sources

Metadata and Data Type Mappings Get Stored in Annotated Files

Runtime Connection Management—Connection Sharing

XQuery-SQL Data Type Mappings

Date and Time Data Type Differences: Timezones and Time Precision

How AquaLogic Data Services Platform Handles Timezone Information

How AquaLogic Data Services Platform Handles Fractional Seconds

Scope Differences for Expressions and Data Types

SQL Pushdown: Performance Optimization

Function and Operator Pushdown

Aggregate Functions

Parameters in Generated SQL Statements

Cast Operation Pushdown

Path Expressions Pushdown

Constant Pushdown

Variable Pushdown

Common Query Patterns

Simple Projection Queries

Where Clause Pushdown

Order By Clause Pushdown

Inner Join Pushdown

Outer Join Pushdown

Semi-Joins and Anti-Semi-Joins

Grouping and Aggregation

Group By Pushdown

Distinct-by Pushdown

Simple Aggregate Pattern

Group-By with a Nested Where Clause Translates to SQL HAVING Clause

Outer Join with Aggregate Pattern

If-Then-Else Pattern

Subsequence Pushdown

Direct SQL Data Services and Pushdown

Distributed Query Pushdown

Preventing SQL Pushdown

Understanding XML Namespaces

Introducing XML Namespaces

Exploring XML Schema Namespaces

Using XML Namespaces in AquaLogic Data Services Platform Queries and Schemas

Best Practices Using XQuery

Introducing Data Service Design

Understanding Data Service Design Principles

Applying Data Service Implementation Guidelines

BEA XQuery Scripting Extension (XQSE)

Introducing the XQuery Scripting Extension

Prolog and Query Body

Procedure Declaration

XQSE Function Declaration

Value Statement and Procedure Call

Block

Set Statement

While Statement

Return Statement

Iterate Statement

Try Statement

If Statement

Changed Element

XQSE Grammar Summary

XQuery-SQL Mapping Reference

IBM DB2/NT 8 (and higher)

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

Microsoft SQL Server 2000 (and higher)

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

Oracle 8.1.x

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

Oracle 9.x, 10.x

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

Sybase 12.5.2 (and higher)

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

PointBase 5.1

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

Teradata V2R5 (and higher)

Data Type Mapping

Function and Operator Pushdown

Cast Operation Pushdown

Other SQL Generation Capabilities

Base (Generic) RDBMS Support

Database Capabilities Information

Data Type Mapping

Cast Operation Pushdown

Other SQL Generation Capabilities


  Back to Top       Previous  Next