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)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-- Previous [61-80] [81-100] [101-120] 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.