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 » Issues exporting SQL Server -> XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + StylusValidator.exe Command Li... (3)
-> + Cannot run Java built in valid... (2)
-> + Windows 10??? (3)
-> + Stylus Custom XML Conversion (... (8)
-> + X14 enterprise and saxon 9.4.0... (3)
-> + Open an XML document in the XM... (3)
-> + How to generate mapping report... (4)
-> + Unresponsive - Custom XML Conv... (2)
-> - Need Help defining Flat File w... (1)
-> + XML to Database (6)
-> + XSD path when associating to a... (3)
-> - Auto EDI File Translation (1)
-> + Need help parsing EDI and crea... (2)
-> + Bug in generating Xml from Dtd (7)
-> + Stylus Studio 15, install erro... (4)
-> + How to create UML from XSD (2)
-> + Java configuration (4)
-> + embedding/starting X15 dircet ... (2)
-> + Stylus X15 R2 environment crip... (5)
-> + Output Method TEXT does not wo... (6)
-- Previous [121-140] [141-160] [161-180] 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
Dustin TaylorSubject: Issues exporting SQL Server -> XML
Author: Dustin Taylor
Date: 06 Aug 2014 07:46 PM
I’m currently evaluating Stylus Studio and I’m trying to export data and related metadata from SQL Server to XML. I currently have this working when hard coding the collection for a single table. This will obviously become tedious with the large number of tables I have. I have tried to dynamically generate the table name and pass to collection(). I have also tried reading in the table list as XML. Either method results in the error “[DataDirect][XQuery][err:FODC0004]Collection URI "file:/xx" does not reference a directory. Is there a way to accomplish what I’m trying to do?

Thanks,

Dustin
Posttop
Ivan PedruzziSubject: Issues exporting SQL Server -> XML
Author: Ivan Pedruzzi
Date: 06 Aug 2014 08:54 PM

Hi Dustin,

What you are describing is not support by DataDirect XQuery.
The processor requires the collection argument to be a literal string in order to build the SQL plan before executing the query.

One possible workaround is generating the XQuery code dynamically, in some use cases works well.

For licensing related question you can contact us at
stylussupport@ivitechnologies.com

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
   
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.