N. America: 800 876 3101 | World: 44 (0) 1753 218 930

XQuery Updates in DataDirect XQuery®

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.

XQJ Tutorial!

Learn about the power of DataDirect XQuery® and XQJ now!

This informative tutorial covers basics and advanced concepts in quick, easy-to-read chapters, and includes four working code samples to help you learn.

Try DataDirect XQuery® Free!

Put the power, scalability, and performance of DataDirect XQuery® to work for you today! Our free trial lets you see for yourself how easy it is to build data integration applications that access and update relational, EDI, and other file formats as XML!

Download DataDirect XQuery® today!