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)
-> + How to disable checking for up... (2)
-> + XML Publisher requires duplica... (4)
-> + Modifying Field Name in XML (4)
-> + Java Runtime Environmnet Libra... (2)
-> + Passing Parameters and Multipl... (4)
-> + Total Newbie Question... where... (3)
-> + XML Pipeline (2)
-> + Encoding problem in text previ... (5)
-> + New Installation on windows 20... (4)
-> - Exception while calling Java m... (1)
-> + Jars to be included for callin... (2)
-> + SXXP0003: Error reported by XM... (2)
-> + Validation error (5)
-> + Windows 10, latest Java, new t... (2)
-> + using help crashes stylus stud... (3)
-> + Web Service Call error (5)
-> + javax.xml.xquery.XQException: ... (2)
-> + Trang translator is not availa... (2)
-> + Replacement for flat2xml (2)
-> + CONV CSV Display Problem (3)
-- 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.