XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
keith simmonsSubject: is it possible to insert into a db table?
Author: keith simmons
Date: 30 Jun 2008 09:55 PM
Hi, I want to copy data from a datasource to a datasource. I am able to query the data form the source database, however I do not understand if it is possible to push the data out to the target db. I reviewed apparently relevant searches here, although the information seems to refer to a feature (DB to XML, create insert) not present in my version (2007 Enterprise). One reference indicated changing the optional output of the xquery to db:///loader.rdbxml (this failed). I do not require a code fragment to embed. This is a one off type of requirement I would like to execute from the ui. Thank you.

Postnext
Ivan PedruzziSubject: is it possible to insert into a db table?
Author: Ivan Pedruzzi
Date: 01 Jul 2008 12:20 AM
Hi Keith,

Here some useful links

Updating Relational Data Using XQuery
http://www.xquery.com/tutorials/xquery-updates1/xquery-updates1.html

XQuery Updates in DataDirect XQuery
http://www.xquery.com/examples/updates/

Bulk load of XML data into a relational database
http://www.xml-connection.com/2008/01/bulk-load-of-xml-data-into-relational.html

Ivan Pedruzzi
Stylus Studio Team

Posttop
keith simmonsSubject: is it possible to insert into a db table?
Author: keith simmons
Date: 01 Jul 2008 10:32 AM
Hi Ivan, Thank you for the prompt reply. I will apply the information in the documents you provided. In the back of my mind I thought there was an more automated method to creating the insert extension. It seems like there used to be a menu driven approach in the 2006 version. -Keith-

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.