XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » xpath query in SQL server
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + SS crashes on load (2)
-> + Can't find file ... then does,... (2)
-> + Diff folders not working (4)
-> + last node in preceding-sibling (3)
-> + SQLXML and Subquery (2)
-> + Xquery - No ReleationalDB opti... (3)
-> + Is a default adapter - not Tid... (8)
-> + Need actual (18)
-> + include path for external enti... (2)
-> - xpath query in SQL server (4)
-> ->xpath query in SQL server
-> ->xpath query in SQL server
-> ->xpath query in SQL server
-> + XPATH Query that works in 2006... (4)
-> + Need help with XML Assignment (3)
-> + Java Compiler in Windows Vista... (6)
-> + Sense:X Only Shows One Enumera... (3)
-> + adding tables and relationship... (6)
-> + preview automatically starts a... (12)
-> + French date in excel 97 using ... (2)
-> + How to maintain large XSL (2)
-> + French date in excel 97 using ... (2)
-> + How to pass EDIFACT as paramet... (3)
-- Previous [1681-1700] [1701-1720] [1721-1740] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Ray WaldronSubject: xpath query in SQL server
Author: Ray Waldron
Date: 04 Apr 2007 07:59 AM
Hi all,
Can someone please help.

I am trying to export a table in SQL 2000 to XML.
From My readings. I need to create an XML Schema that will be used to define the finished XML from the Table.
I have used Stylus Studio to create an XML from the table and then an XML Schema from the XML..
My question is...
I now have a table in SQL 2000 and an XML schema to create an XML but how do I run this in SQL 2000 and then schedule it to run every day.
I think I need to Use xpath query that creates the xml but I don't know where to start this. Can you please help.
Or is this all to be done using Stylus Studio and linked to SQL DB
Ray..
Postnext
Ivan PedruzziSubject: xpath query in SQL server
Author: Ivan Pedruzzi
Date: 04 Apr 2007 10:19 AM

Hi Ray,

If you are running Stylus Studio 2007 Enterprise, you can just use DataDirect XQuery, no need of mapping of any sort.

Please have a look to the video tutorial
http://www.stylusstudio.com/videos/ddxqdemo/datadirectxquery.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Ray WaldronSubject: xpath query in SQL server
Author: Ray Waldron
Date: 04 Apr 2007 11:43 AM
Hiya Thx for the reply..
I have viewed the tutorial..Very good..
However I think this may be overkill..

Jus a couple of quick questions.
How do I quickly use the xquery to create an xml from all columns in the linked SQL table?
How do I schedule this to run evry say 1 Hour?
and where does the xml get saved ?

Thx in advance.
Ray
Posttop
(Deleted User) Subject: xpath query in SQL server
Author: (Deleted User)
Date: 05 Apr 2007 04:04 AM
Hi Ray,
in order to simply get the data, just drag the table into the XQuery editor, and pick the collection('xxx') choice; running this query will get you a dump of the data in the default format.
If you need to run this with a schedule, you can enter the target file name in the Output URL setting of the scenario, choose the DDXQ processor and then generate a Java class to run the XQuery. At that point you can compile it and set up the task scheduler/cron to run it with the required frequency.
Be advised that this could require additional runtime licenses for either DDXQ and/or Stylus runtime components; if you don't need the performance and scalability provided by DDXQ or the flexibility of having a Java code that can be deployed on different platform (including web services/application servers) you can try using the free command line tool StylusXql to run the original XQuery.

Hope this helps,
Alberto
   
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.