Overview

In XQuery Mapper, simple drag-and-drop techniques create calls to built-in DataDirect XQuery functions - ddtek:sql-insert, ddtek:sql-update, and ddtek:sql-delete - that perform update operations on relational databases. For example, this XQuery code, which performs an INSERT operation on the Products table, was created with a few simple mappings:


ddtek:sql-insert("sqlserver_pcipeduzz :Northwind.dbo.Products", "ProductName",$Products/ProductName, "SupplierID",$Products/SupplierID, "CategoryID",$Products/CategoryID)

Stylus Studio provides support for numerous relational databases, including Microsoft SQL Server, Informix, and Oracle. For a complete list, see Supported Databases.

For information on connecting to a relational database, see Creating a Database Connection.

< Previous| Next >

Download a 15 Day Free Trial Now >

See What's New in Stylus Studio® X16 XML >

Buy Stylus Studio Now >

Overview

Stylus Most Wanted