Contents for XQuery and XQSE Developer’s Guide

Introducing the Oracle Data Service Integrator XQuery Engine

XML and XQuery

XQuery Use in Oracle Data Service Integrator

Supported XQuery Specifications

Learning More About the XQuery Language

Oracle’s XQuery Implementation

Oracle 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

Using Mutators for Updates

fn-bea:changed-element

fn-bea:insert-into

fn-bea:delete

fn-bea:replace-value

Mutator Function Examples

Update Based on Simple Parameters

Update Based on Complex Input Parameters

Example—Replacing Values Based on Complex Input Parameters

Example—Inserting a New Element Based on Complex Input Parameters

Update When the Parameter Structure Matches the Return Type

Example—Replacing all Values in a Complex Element

Update Based on Differences Between Old and New Values

Example—Updating Based on Parameter Differences Determined Through a Series of if Statements

Example—Updating Based on Parameter Differences Determined Through Iteration

Update Using Additional Data

Example—Retrieving Additional Data Before Updating

Update Operation Replication

Example—Updating Multiple Data Sources

Unsupported XQuery Functions

Restrictions Related to Client Ad-Hoc Queries

Implementation-Specific Functions and Operators

Oracle XQuery Language Implementation

XQuery Language Support (and Unsupported Features)

Extensions to the XQuery Language in the Oracle Data Service Integrator 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 Oracle Data Service Integrator Handles Timezone Information

How Oracle Data Service Integrator 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 Oracle Data Service Integrator Queries and Schemas

Best Practices Using XQuery

Introducing Data Service Design

Understanding Data Service Design Principles

Applying Data Service Implementation Guidelines

Oracle 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