Tutorial: Updating Relational Data - Intro

DataDirect XQuery® supports XQuery updates to relational database tables from inside an XQuery by providing three built-in XQuery update functions. These functions are: ddtek:sql-insert, ddtek:sql-update, ddtek:sql-delete. The DataDirect XQuery® update functionality requires extensions to the XQuery processing model for function declaration, XQuery expressions, and snapshot semantics.

XQuery Update: Table of Contents:

ddtek:sql - Insert, Update, Delete

Learn to: insert a single record in a database table, update records in a database table, and delete records in a database table.

Extensions to the XQuery Processing Model

To support XQuery updates, DataDirect XQuery extends the XQuery processing model, as discussed in this section.

Executing Updates in XQJ

Follow along with an example to learn how to execute an updating expression in XQJ using an XQExpression object.

Understanding the Transactional Behavior of DataDirect XQuery Updates

This section describes how DataDirect XQuery supports transactions, transaction isolation levels, and distributed transactions.