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 » XQuery Help and Discussion » Complete SQL Server database transform to XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2016)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-> + Problems with FTP upload via X... (3)
-> + What path notation works when ... (6)
-> - Xquery Exception (1)
-> + [java] [Fatal Error] Test.xml:... (2)
-> + unable to produce correct XML ... (2)
-> + where can I find stylusxql uti... (3)
-> + Trouble Mapping Multiple Eleme... (3)
-> - input parameter (1)
-> - set element value (1)
-> + Xquery Performance Issue (21)
-> + Run Xquery Program using Java (3)
-> + XQuery XML to CSV (3)
-> + XQuery MySQL connector (4)
-> + XQuery with JDBC connection is... (3)
-> + Create FTP Server (2)
-> + XQuery Nested Loop Lookup (5)
-> + Xpath using a Variable for [@I... (2)
-> - My xqDoc option is disabled. (1)
-> + Xpath ancestor selection (4)
-> + Exception: sequence of more th... (2)
-> + XQUF usage (3)
-> - xquery rule execution (1)
-> + Loving XQuery (3)
-> + Cross Referencing Country Name... (4)
-> + Creating a Pivot Table with xQ... (2)
-> + Error Please Help (3)
-> - Error Please Help (1)
-> + XPath descendant question (2)
-> + java/lang/OutOfMemoryError Run... (2)
-> + Xquery key value lookup (8)
-> + Improve xQuery Performance (3)
-> + MS SQL Server - Disable order ... (10)
-> + proper use of fn:distinct-valu... (2)
-> + Ignore DTD (7)
-> - Thanks Ivan (1)
-> + Trying to get 2nd value of nod... (5)
-> + Outer joins (4)
-> + Figured Out Issues From Last P... (2)
-> + Best Way To Generate Complex X... (3)
-> + count in xquery (4)
-> + left/right presentation (3)
-> + new to stylus - connecting to ... (2)
-> + XQuery problem with namespaces (4)
-> + .conv and xquery problem (3)
-> + Can pass text into CONV file (2)
-> + doc-available not working as e... (4)
-> + ddtekjava write to file only e... (5)
-> + arrayindexoutofbounds with ddt... (7)
-> + XSD: Structure definition depe... (2)
-> + Fatal Error whitespace expecte... (3)
-> + Executing a pipeline sequence ... (2)
-> - Data Transfer (1)
-> + Specifying the SEF File Locati... (4)
-> + Multiply numbers... (2)
-> + Using Generated Java-Code... (5)
-> + Mapper does not show all nodes... (5)
-> - Xul tree search using XQuery X... (1)
-> + converting XML to CSV (2)
-> - datadirect licenses (1)
-> + generate a uuid (2)
-> + Help to write Xquery (2)
-> + XQuery java ddtek:serialize-to... (2)
-> + EDI to XML Automation (2)
-> + Generating XQUERY to use in Or... (2)
-> + Stylus is not easy to learn XQ... (2)
-> - java.lang.OutOfMemoryError (1)
-> + how to save to xml format (2)
-> + Formating a date in xquery (2)
-> + two xml statements when mappin... (5)
-> + XQuery (2)
-> + saxon-license.lic Not Found (2)
-> + hands off conversion to final ... (2)
-> + fn:substring in XQuery to Orac... (4)
-> + Using Saxon with XQuery to ins... (4)
-> + Can't SAVE or DO a SAVE AS Fro... (2)
-> + Saxon Unexpected token < e o f... (2)
-> + Inserting and selecting data i... (2)
-> - convert sql statement into xml... (1)
-> + need help in converting this a... (2)
-> + IS IT POSSIBLE TO DO AN XQUERY... (2)
-> + XQUERY RESULTS NOT IN PROPER F... (2)
-> + how to get data from database ... (2)
-> + tree view in xquery (2)
-> + Need help with SelectsingleNod... (5)
-> - counting in query (1)
-> + WebApplication with Xquery (3)
-> + Limit to number of elements in... (3)
-> + Automate xquery Conversion (2)
-> + ddtek:wscall problem (2)
-> - Problem with case sensitive (1)
-> + Is this the formal tech suppor... (2)
-> + problem with Conditional Expre... (5)
-> - problem with Conditional Expre... (1)
-> + connect to mysql for xquery? (2)
-> - NOOB Help (1)
-> - Getting rid of empty namespace... (1)
-> + Xquery not yielding results (3)
-> - fn:replace() inserting spaces ... (1)
-> + Xquery XML document with spcei... (7)
-> + XLS (MS Excel) to XML Converte... (3)
-> + Little Help :))) (2)
-> + Xquery tag position (2)
-> - Can I connect to MonetDB/XQuer... (1)
-> + Is there a way to format a num... (2)
-> + Please help convert SQL query ... (3)
-> + Connect to SQL Server Express ... (3)
-> - Convert HTML to XML within C# ... (1)
-> + return different result based ... (7)
-> + Java Heap Space (2)
-> + XQuery Results export to multi... (3)
-> + NO RETURN (5)
-> + Part of a csv into a current X... (3)
-> + How to escape ampersand in xqu... (2)
-> + How to Convert CSV lines to in... (5)
-> + Data connection Stylus Studio ... (2)
-> + Nested XQuery FLOWRs with RDBM... (3)
-> + observing xquery at work (2)
-> + alternative for 'exists' (4)
-> + Xquery and webpages how? (2)
-> + Help with another DataDirect p... (5)
-> + How to resolve XPTY0004 error (3)
-> + Search a sequence of siblings ... (3)
-> + DataDirect process getting XPS... (2)
-> + Find the parent who doesn't ha... (3)
-> + Help with a basic FLWOR query (3)
-> + xQuery Efficient Performance B... (5)
-> + How to break down a sequence a... (3)
-> + Xquery returning odd number fo... (2)
-> + Problems with Java date parame... (3)
-> + Xquery filter on multiple valu... (2)
-> + Xquery filter by using contain... (5)
-> + multiple xslt execution using ... (2)
-> + How to access to global variab... (6)
-> + "Value can not be converted to... (4)
-> + (simple) problem with xquery (3)
-> + Version of xQuery Included wit... (3)
-> + xQuery 1.0 Produces XPTY0004 E... (3)
-> + Replace Node with Set of Nodes (2)
-> + Unable to Use File Name as Ext... (5)
-> + EDI to XSD and validation (2)
-> + Sample XQuery extension using ... (2)
-> + Another EDI problem (7)
-> + Removing xmls:od and xmls:xsi ... (2)
-> + Configuring MarkLogic with Sty... (10)
-> + EDI to XML (7)
-> + Can't write to SQL-Server (4)
-> + XQuery and SQL-Server (2)
-> + Connection to MS SQL Server in... (2)
-> + copy/modify with Stylus Studio... (5)
-> - copy/modify with Stylus Studio... (1)
-> + [SQLServer JDBC Driver]Value c... (5)
-> + wild card chracter usage in XS... (2)
-> + Xquery with SQL NEWID function (4)
-> + Change Only One Line (5)
-> + Format DB xQuery results (3)
-> + Adding MsSQL Database to XQuer... (3)
-> + Need help with using XQuery in... (2)
-> + please help! simple XML transf... (2)
-> + xquery for invoice data (3)
-> + Xquery to cross reference two ... (3)
-> + how to list distinct value? (5)
-> + Reading XML Files Across Netwo... (8)
-> + I want to automatically check ... (4)
-> + Parent tags (5)
-> + Remove Empty tags (2)
-> + dynamic function call | dynami... (3)
-> + Can I define a function like f... (3)
-> + remove empty tags (4)
-> + Loops (7)
-> + flat to XML with xQuery (4)
-> + Xquery for timer based events. (2)
-> + Cleaning up Word 2007 xml (3)
-> + Xquery string-pad function (5)
-> + DB to XML Data Source (2)
-> + XML Streaming not working (2)
-> + XQuery General Question (11)
-> + ERROR XQueryMediator Error dur... (2)
-> + Print Date in XML File (2)
-> + Aritmetic in Xquery (2)
-> + Use content of node as node na... (2)
-> + Better way to do this? (3)
-> + Get output line by line!! (2)
-> + Use of if-then-else (2)
-> + Manipulation of XQuery output!... (4)
-> + Subtract times (6)
-> + Using xQuery to call a Convers... (3)
-> + How to add a custom class to t... (3)
-> + How to get rid of multiple occ... (2)
-> + Problem with conditional JOINi... (8)
-> + XQuery editor whitin Stylus St... (3)
-> + Get rid of spaces in returned ... (4)
-> + Can XQuery be embeded in a Jav... (2)
-> + Need help on converting <br... (3)
-> + postgresql (3)
-> + No format-number functionsupp... (4)
-> + Swapping elements using XQuery... (2)
-> + Trying to contact DataDirect d... (3)
-> + External Java functions with b... (5)
-> + Looking for xQuery help (6)
-> + Built-in processor & filtered ... (2)
-> + Multiple Sibling Matches (2)
-> + Issue with data($element) (4)
-> + convert text to xml from more ... (2)
-> + xquery syntax (2)
-> + SQL Table To XML using XQuery (4)
-> + delimiting values of attribute... (3)
-> + empty child nodes (9)
-> + Illegal XML characters (4)
-> - Complete SQL Server database t... (34)
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> ->Complete SQL Server datab...
-> + Prevent xquery from converting... (8)
-> + Another edi question. (6)
-> + Running xquery with a source c... (4)
-> + xml to edi segment count quest (3)
-> + Running xquery from the comman... (7)
-> + How to change the node name in... (5)
-> + How to loop through a set of e... (10)
-> + Can I pass a parameter/vaiable... (3)
-> + generating an XML file (3)
-> + generating log files of Xquery... (2)
-> + Stylus Studio crashes when edi... (3)
-> + Checking for Values in an Arra... (3)
-> + Adding embedded functions (11)
-> + multiple DTPs at the same leve... (2)
-> + java.lang.OutOfMemoryError: Ja... (3)
-> + xml validation against wsdl (2)
-> + Using same Xquery (4)
-> + Changing name value pairs to t... (4)
-> + removing unwanted attributes r... (4)
-> + Repeated Crashing of System (2)
-> + Create multiple XML Files (5)
-> + Best xQuery engine? (2)
-> + Xquery outputs XML attributes ... (4)
-> + DataDirect SequeLink as a DB-t... (2)
-> + Using same xquery for 2 xml fi... (5)
-> + Performance of XQuery (2)
-> + fail to use Saxon Process for ... (4)
-> + Conditional statements in xque... (2)
-> + Option Declaration Using Saxon (2)
-> + Multiple option declarations (2)
-> + Importing modules with a Custo... (3)
-> + Possible bug: Problem with aut... (5)
-> + getting the value of an attrib... (4)
-> + Memory problems using xQuery (6)
-> + Adding a namespace (6)
-> + [DataDirect][XQuery][err:FODC0... (9)
-> + Mapping Trouble (4)
-> + Two level grouping (5)
-> + Error: A parameter of the oper... (3)
-> + Grouping in xQurey (Nested For... (7)
-> + err:XPST0005 - Error at line 9... (4)
-> + Error at line 1, column 126. U... (6)
-> + Strange output (2)
-> - word count for each category (1)
-> + Need help with this xquery (2)
-> + XML DOM (3)
-> + License issues related to XQue... (3)
-> + XQuery, ddtek:wscall, and an e... (9)
-> + How to give sub equation nos (3)
-> + XML DOM (3)
-> + forcing empty elements to have... (4)
-> + SQL Server 2005 XQuery help (4)
-> + Type error (5)
-> + MarkLogic queries (2)
-> + relative uri (3)
-> + Recursive Template Funcion Fro... (2)
-> - Create RDF for xml (1)
-> + Schema validation errors (2)
-> + KEYWORD EXTRACTION FROM XML DO... (6)
-> + Newbie struggling with nested ... (4)
-> + Path evaluation bug (?) concer... (2)
-> + XPath query (3)
-> + make sequence (4)
-> + XPath Query Editor Schema-Awar... (3)
-> + Newbe To This Form of programm... (2)
-> + Connection to remote database (2)
-> + Addnamespace using xquery (4)
-> + FATAL ERROR: Invalid document ... (3)
-> + FLOWR Loop Counter (5)
-> + Stylus Studio XML generation f... (2)
-> + Potential bugs? (2)
-> + hierarchical XML into tables (2)
-> + Incremental line counts (4)
-> + preceding-sibling syntax help ... (2)
-> + Creating hierarchical identifi... (5)
-> + Convert decimal to Hex. (3)
-> + XQuery automated comparison of... (3)
-> + validating schemas (2)
-> + very simple fn:string() proble... (5)
-> + Need help with a XSL file (2)
-> + Problems with conversion from ... (3)
-> + MS Sql Server (2)
-> + XQuery equivalent of xsl:resul... (2)
-> + tokenizing a string - problem ... (3)
-> + XQuery and eXist error process... (2)
-> + Deploying an xquery file with ... (2)
-> + Newbie struggling with simple ... (4)
-> + summing up the figure in the n... (8)
-> + Variable as part of a tag? (2)
-> + xquery element tag name (2)
-> + xquery - question for count fu... (3)
-> + get multiple values from multi... (4)
-> + Is it possible to add new data... (7)
-> + Can't connect to DB - MS SQL S... (16)
-> + sequence distinct values (4)
-> + XSQL QUERY (2)
-> + External xquery functions (2)
-> + Error in Xquery V3.0 (7)
-> + Problem getting distinct value... (2)
-> + XQuery reference book recommen... (2)
-> + it's possible to have a where ... (2)
-> + XSLT sorting parent nodes by m... (2)
-> + Catalyst EDI Mapping (2)
-> + h2 element is there but XQuery... (2)
-> + Adding the XML header to an ou... (2)
-> + Newbie question regarding dyna... (2)
-> + Group parent elements in targe... (5)
-> + Need XPath to return just imme... (4)
-> + XQUERY Java run-time error (4)
-> + dbxml and collection() (2)
-> + Nothing returned when namespac... (3)
-> + XQERY and Stylus Studio suppor... (3)
-> + x12 837 convert to xml fail wi... (3)
-> + Choose more than one attribute (2)
-> + XQuery Engine (4)
-> + finding nodes in source docume... (2)
-> + unable to create any xquery (3)
-> + counter in xquery (5)
-> + How to change JVM settings -Xm... (4)
-> + Postgresql (3)
-> + Can I call an xquery file from... (5)
-> + How to output a text with a mi... (3)
-> + Mapping - How Include the Sche... (6)
-> + XQuery beginner problem (2)
-> + No output from StylusFile Conv... (3)
-> + getting all nodes leading up t... (3)
-> + Java exception when apply regu... (5)
-> + X12 resources not reachable (T... (13)
-> + XQuery error on Oracle views (5)
-> + Results multiplied by number o... (3)
-> - Continous sequence check (1)
-> + No results for second row of s... (14)
-> + Problems connecting to DB2/400... (6)
-> + External Class : Invalid linki... (8)
-> + Error during SQL execution: [O... (2)
-> + Warnings when running Schema a... (2)
-> + XQuery basics (2)
-> + XPath Query Editor - not visib... (3)
-> + Document loading and unloading (3)
-> + Xpath to return xmlns (3)
-> + How to execute xQuery and exec... (3)
-> + Schema Aware Saxon (5)
-> + Want to execute a XQuery by AP... (7)
-> + Use a user-defined adapter as ... (2)
-> + RDB collections versus DB-to-X... (5)
-> + XMLTABLE WITH COLUMN OF ALL NO... (5)
-> + Xquery question (4)
-> - XQuery 1.0 is now a Proposed R... (1)
-> + I can't seem to get my xml "re... (7)
-> + Custom pipeline elements (4)
-> + FIND ALL ELEMENTS WITH SAME NA... (3)
-> - CONCATENATE COMPLEX TYPE ELEME... (1)
-> + XQuery & MySQL (4)
-> - Referring elements from an imp... (1)
-> + Selecting operator from XML to... (5)
-> + copy-namespaces mode (5)
-> + XQuery and Javascript 1.5+ on ... (2)
-> + XQuery sort & extract data (4)
-> + [DataDirect][XQuery]No value h... (9)
-> + About typing system for XQuery... (5)
-> + root() vs // - saxon and built... (3)
-> + XQuery or XPath "between" func... (4)
-> + Xpath Query Editor button grey... (3)
-> + Processing Instructions, Built... (4)
-> + XPath parser in Java (3)
-> + XQuery "declare xmlspace prese... (10)
-> + Save results of XQuery as CSV? (7)
-> + Cleanup and combine question (3)
-> + xquery function from within xs... (4)
-> + Saxon XQuery error (4)
-> + xquery and 1gb xml files (3)
-> + How can i output key words suc... (5)
-> + Viewing XQuery (4)
-> - Webinar: Using XQuery and Data... (1)
-> + Java code generated by Xquery ... (6)
-> + Multiple items in return (2)
-> + Confused using match (2)
-> + Counting distinct node types (7)
-> + XQUERY Newbie question (3)
-> + Receiving a function as a para... (7)
-> + Xpath Version - and Doc for Re... (2)
-> + Convert namespace? (2)
-> + Can I search for one line and ... (3)
-> + Reading Data from Soap Respons... (2)
-> + Access To XML Query Question (4)
-> + Xquery find avg and count (3)
-> + Bug using global variables in ... (3)
-> - Problem uploading XSLT to xml ... (1)
-> + Bug? HTMLTidy does not support... (2)
-> + Finding a string within an XML... (4)
-> + Store query result in java.lan... (2)
-> + Comparing databases and XML. (3)
-> + namespace information with XQu... (4)
-> + Single row to multiple row tra... (3)
-> + Webservice call failed (2)
-> + Stylus Studio has encountered ... (2)
-> + My XQUERY on Berkley DBXML s... (2)
-> + Filtering multiple values from... (5)
-> + SaxonB8.4 testing (8)
-> + Problem with oracle large tabl... (3)
-> + incorrect syntax? (3)
-> + XQUERY-based app usage (4)
-> + position() and last() in XQuer... (3)
-> + Returning Values (5)
-> + new to XQuery- "expected cardi... (2)
-> + using XQuery to keep all data ... (2)
-> + search in XQuery (6)
-> + Defined source and destination... (2)
-> + Stopping running xquery in R2 (4)
-> + XQuery where can i use it? (5)
-> + Scheduling the conversion (2)
-> + Converting Oracle table to XML... (5)
-> - Formating and Indentation Pres... (1)
-> + Omiting the XML declaration fr... (4)
-> + Define function (4)
-> + External Java class problems (15)
-> + C++/COM API for XQuery (3)
-> + PROBLEM AT THE DECLARATION OF ... (3)
-> - Cobol Flat file to XML (1)
-> + xpath question (2)
-> + XQST0059 cannot locate the req... (6)
-> + How to generate XML with proce... (2)
-> + ODBC Connection refused (12)
-> + node search and replace (3)
-> + generate xml file on web serve... (5)
-> + How to navigate to a ref node (5)
-> + How to query when a default na... (2)
-> + full xpath to a node (3)
-> + Performance bench (2)
-> + how to run xquery using java (2)
-> + [ convert dtd to xsd ] (3)
-> + How to map a recursive node? (9)
-> + java class implementing extern... (3)
-> + context to context reference (2)
-> + Problems with Replace (7)
-> + Use of special characters in X... (5)
-> + How to write XML Parser IN VC+... (2)
-> + Xquery (5)
-> + Trivial XQUERY application que... (2)
-> + XML as a data model (2)
-> + XQuery (2)
-> + Relative path (2)
-> + Support for xml is-idref (4)
-> + Accessing the document context... (3)
-> + Getting recursion return type ... (4)
-> + Parsing XMLFormatted as String... (5)
-> + XQuery Replace (2)
-> - How to join the two table usin... (1)
-> + Update variable value inside b... (5)
-> + Run XQuery on XMLDB databases (2)
-> + Treatment of reserved characte... (6)
-> + XQuery Core (6)
-> + Built-In Saxon 8.4 processor (3)
-> + dynamic order by clause (3)
-> + Dynamical xpath (3)
-> + How to use xquery? :) (2)
-> + Converting SQL query to XQuery (4)
-> - New XQuery Primer: Learn XQuer... (1)
-> - XQuery Co-Author and XML Indus... (1)
-> + sequence to collect (3)
-> + user defined functions in xque... (2)
-> + Need second set of eyes to deb... (2)
-> - Xquery calling Java function f... (1)
-> + Xquery on existing XML files i... (2)
-> + Need Help Resorting (11)
-> + "for" clause question (2)
-> + New XQuery Video: Using DataDi... (2)
-> + data() function not returning... (2)
-> + XSL-FO using RenderX's XEP on ... (4)
-> + Xquery to find sample data fil... (4)
-> + Xquery to find sample data fil... (4)
-> + Error with Berkeley XML DB and... (13)
-> + Berkeley XML DB & Professional... (3)
-> + question (2)
-> + Writing UDDI API's in XQuery (2)
-> - DataDirect XQuery Enables XQue... (1)
-> + Xquery to MS/SQL? (8)
-> + Left Outer Join in XQuery (2)
-> - New XQJ Tutorial and Example F... (1)
-> + asked (2)
-> - generate XML file from tables ... (1)
-> - XQuery interest growing: DevX (1)
-> + New to XQuery question (2)
-> - Help Support XQuery in the Mic... (1)
-> + Xquery and Web Service Caller (4)
-> + XQuery from JavaScript? (4)
-> + Find Maximum Numeric Value in ... (2)
-> + Can you use XQuery and SQL/XML... (2)
-> + XQuery and Relational Data map... (2)
-> + STyluus and C# (MS) (2)
-> - XQuery making headlines (again... (1)
-> + XQuery Syntax (2)
-> - XQuery in Outer Space (1)
-> + import several modules in a xq... (2)
-> - Developers Flock to XQuery Spe... (1)
-> + UPDATE (2)
-> + global variable (4)
-> + XQuery on all XML Files in a D... (12)
-> + Stylus Studio Interoperability... (5)
-> - Genereating values in a combob... (1)
-> - SQL Server 2005 "Yukon" (1)
-> - XQuery Drivers (1)
-> - Database Trends and Applicatio... (1)
-> - Why XQuery? How new XML Standa... (1)
-> - Develop, Edit and Debug XQuery... (1)
-> + Native XML Database Tools (3)
-> - XQuery in Bank Systems and Tec... (1)
-> + User functions (5)
-> + Setting Values for External Va... (4)
-> - XQuery 2005 Road Show (1)
-> - XQuery Introduction (1)
-> - New XQuery Developer Awards Pr... (1)
-> + Convert String to xml document... (2)
-> + import de modules (7)
-> + String to XML conversion in a ... (2)
-> + DML language (2)
-> + Newbie Xquery problem to solve (7)
-> - What is XQuery? (1)
-> - XQuery Talk: Priscilla Walmsle... (1)
-> + Learn XQJ : The XQuery API for... (3)
-> + XQuery to consolidate modular ... (6)
-> + problem with xquery (4)
-> + use cases (5)
-> - XQuery and XQJ Talk with Jason... (1)
-> + append the output of the xquer... (3)
-> + Problem with command line argu... (4)
-> - Can you associate hundreds of ... (1)
-> + PARAMETER VALUES IN STYLUS STU... (2)
-> + Problem with stylusxql calls (5)
-> - Join us for Eggs & XML at the ... (1)
-> + More about Java extensions and... (2)
-> + Stylus Studio Crashes with Jav... (6)
-> - An Interview with Jason Hunter... (1)
-> + attribute order in query resul... (3)
-> - Interview with XQuery Guru Dr.... (1)
-> + SequenceType matching failed" ... (2)
-> + XQuery tutorial (3)
-> - W3C Releases Public Working Dr... (1)
-> + Problem with a function (3)
-> + Problem with Stylus Studio 5.3 (5)
-> + Studio Studio crashes (7)
-> + STYLUSXQL (8)
-> + Execute a Query From the Comma... (2)
-> + Import Modules. (8)
-> + User-Defined Functions (3)
-> + new to Xquery (3)
-> + XQuery engines (4)
-> + APIs or OCXs (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 14 Aug 2008 11:30 AM
OK, so far so good. I have a fairly complex relational db => XML transform involving joins on about 40 tables. Good news is that it works, and very quickly (when implemented using a FOR XML style query on SQL Server it worked, but slowly, a 10 record pull would take 10 mins - now, using XQUERY I can get 1000 records in about 30 secs). Bad news is that I need help with the next bit. I can chunk out small files manually (run the XQUERY and save off the preview results), but the is a fairly manual process and I seem to be limited to 1-5000 record pulls before bad things happen (JAVA heap/out of memory errors). I currently have about 470,000 records that I need to process (with substantially more to follow). How can I automate this? I would like to launch something that would build a series of xml files (each containing, say, 10000 records... maybe 10MB) that would constitute a complete dump. How do I begin?
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 14 Aug 2008 11:42 AM
This is the typical mechanism we use to split large tables into multiple XML files; you can probably adapt it to work in your specific context:

declare variable $pageSize := 1000;
let $table := collection("myTable")/myTable
let $groupCount := xs:integer(fn:ceiling(count($table) div $pageSize))
for $g in 1 to $groupCount
let $group := $table[fn:position() gt ($g - 1) * $pageSize
and fn:position() le $g * $pageSize]
return (ddtek:serialize-to-url(
<root>{$group}</root>,
concat("file:///c:/temp/split",$g,".xml"), "indent=yes"))
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 14 Aug 2008 03:54 PM
ok, took a stab at this, but I'm doing something wrong... here's what the beginning of my file looks like:

<Papers>
{
declare variable $pageSize := 1000;
let $table := collection("xAce.dbo.singles")/singles
let $groupCount := xs:integer(fn:ceiling(count($table) div $pageSize))
for $g in 1 to $groupCount
let $group := $table[fn:position() gt ($g-1) $pageSize and fn:position() le $g*$pageSize]
return (ddtek:serialize-to-url(<root>{$group}</root>,concat("file:///G:/x/xml/ace/test",$g,".xml"),"indent=yes"))
<AcademicPaper>
{
if( $singles1/TI ) then
<Title>
{$singles1/TI/text()}
</Title>
else ()
}
{
if( $singles1/FT ) then
<ForeignTitle>
{$singles1/FT/text()}
</ForeignTitle>
else
()
}

==========================================

this gives me the following error:

[DataDirect][XQuery][err:XPST0003]Error at line 3, column 10. Expected "}", but encountered "variable".

what obvious thing am I missing?
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 14 Aug 2008 04:06 PM
See attached. I couldn't run it of course, but it looks about right.


DocumentxQuery.xquery
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 14 Aug 2008 04:16 PM
nice... misunderstood where to put the code... ah well... new problem:

[DataDirect][XQuery][err:XPST0017]Error at line 7, column 9. Unknown 3-argument function "ddtek:serialize-to-url"

I'm using the 2007 Enterprise Suite version, do I not have that function?
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 14 Aug 2008 04:22 PM
Unfortunately v2007 bundles DataDirect XQuery 3.0, which doesn't support serialize-to-url().

If you have active AUP (Annual Upgrade Protection), you can upgrade for free to v2008 Release 2, which bundles DataDirect XQuery 3.1 (www.stylusstudio.com/aup). If you want to try it out, you can download and install it from http://www.stylusstudio.com/download; you don't need to uninstall v2007.

Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 14 Aug 2008 04:29 PM
ouch, the older serialize function won't push output into file?
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 14 Aug 2008 04:35 PM
No; that's the role of serialize-to-url()...
http://media.datadirect.com/download/docs/ddxquery/allddxq/reference/xquerysupport7.html#wp298908

Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 19 Aug 2008 03:26 PM
**********************************************************************
**********************************************************************
**********************************************************************
ok, finally got 2008 activated... now, I have a question about the code you posted:
**********************************************************************
**********************************************************************
**********************************************************************

declare variable $pageSize := 1000;

let $table := collection("xAce.dbo.singles")/singles
let $groupCount := xs:integer(fn:ceiling(count($table) div $pageSize))
for $g in 1 to $groupCount
let $group := $table[fn:position() gt ($g - 1) * $pageSize and fn:position() le $g * $pageSize]
return (ddtek:serialize-to-url(
<Papers>
{
for $singles1 in collection("xAce.dbo.singles")/singles
where ($singles1/autoID >= -10) and ($singles1/autoID <= -1)
return

**********************************************************************
**********************************************************************
**********************************************************************
my question is here, shouldn't this block hold some sort of reference to the group collection rather than the original where clause I was using???
**********************************************************************
**********************************************************************
**********************************************************************



<AcademicPaper>
<Title>
{$singles1/TI/text()}
</Title>
{
if( string-length($singles1/FT/text()) ) then
<ForeignTitle>
{$singles1/FT/text()}
</ForeignTitle>
else
()
}

[[[ big chunk omitted ]]]

</AcademicPaper>
}
</Papers>,
concat("file:///G:/x/xml/ace/test",$g,".xml"),"indent=yes"))
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 19 Aug 2008 03:36 PM
Yes, sorry; the nested loop should not be...

for $singles1 in collection("xAce.dbo.singles")/singles

...but...

for $singles1 in $group
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 19 Aug 2008 03:38 PM
...actually, you may want to move your where condition up...
declare variable $pageSize := 1000;

let $table := collection("xAce.dbo.singles")/singles[autoID >= -10 and autoID <= -1]
let $groupCount := xs:integer(fn:ceiling(count($table) div $pageSize))
for $g in 1 to $groupCount
let $group := $table[fn:position() gt ($g - 1) * $pageSize and fn:position() le $g * $pageSize]
return (ddtek:serialize-to-url(
<Papers>
{
for $singles1 in $group
return
<AcademicPaper>
...
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 19 Aug 2008 03:46 PM
no, the where clause was just for testing so that I wouldn't try to pull all 477,000 records each time.

new question - where is the temp file that it is writing to? can I move it? (getting a 'not enough space' error)

*********************************************************************

com.ddtek.xquery3.XQException: [DataDirect][XQuery]Error during SQL setup: [SQLServer JDBC Driver]IO Error writing temp file: There is not enough space on the disk

at com.ddtek.xquery3.xqj.Util.createXQException(Util.java:241)

at com.ddtek.xquery3.xqj.layer.DDXQResultSequence.getXQueryStreamReader(DDXQResultSequence.java:588)

at com.ddtek.xquery3.xqj.layer.DDXQAbstractSequence.writeSequence(DDXQAbstractSequence.java:456)

Caused by: com.ddtek.xquery.util.XQueryException: [EX5100][DataDirect][XQuery]Error during SQL setup: [SQLServer JDBC Driver]IO Error writing temp file: There is not enough space on the disk

at com.ddtek.xquery.extractor.util.SqlUtil.createXQueryException(SqlUtil.java:202)

at com.ddtek.xquery.extractor.sql.generic.SqlGlobalCollection.RunSqlBatch(SqlGlobalCollection.java:1102)

at com.ddtek.xquery.extractor.sql.generic.SqlGlobalCollection.RunSqlBatch(SqlGlobalCollection.java:1123)

at com.ddtek.xquery.extractor.sql.generic.FactoryImpl.checkTempTable(FactoryImpl.java:173)

at com.ddtek.xquery.extractor.sql.generic.SqlGlobalCollection.init(SqlGlobalCollection.java:112)

at com.ddtek.xquery.extractor.ExtractorStatement.createSQL(ExtractorStatement.java:508)

at com.ddtek.xquery.extractor.ExtractorStatement.prepareXQuery(ExtractorStatement.java:487)

at com.ddtek.xquery.extractor.ExtractorPreparedStatement.<init>(ExtractorPreparedStatement.java:48)

at com.ddtek.xquery.extractor.ExtractorConnection.prepareStatement(ExtractorConnection.java:244)

at com.ddtek.xquery.extractor.ExtractorConnection.prepareStatement(ExtractorConnection.java:232)

at com.ddtek.xquery.mediator.plan.SourcePhysOpImpl._prepareStatement(SourcePhysOpImpl.java:480)

at com.ddtek.xquery.mediator.plan.SourcePhysOpImpl._prepareStatement(SourcePhysOpImpl.java:523)

at com.ddtek.xquery.mediator.plan.SourcePhysOpImpl$SourceContext.setQuery(SourcePhysOpImpl.java:1505)

at com.ddtek.xquery.mediator.plan.BatchSourcePhysOpImpl.execute(BatchSourcePhysOpImpl.java:173)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:106)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinLetTagPhysOpImpl.next(JoinLetTagPhysOpImpl.java:120)

at com.ddtek.xquery.mediator.xtuple.LetReturnSequence._materialize(LetReturnSequence.java:118)

at com.ddtek.xquery.mediator.xtuple.Sequence.materialize(Sequence.java:125)

at com.ddtek.xquery.mediator.xtuple.Sequence.getValue(Sequence.java:148)

at com.ddtek.xquery.mediator.plan.ExecutionPlanContextImpl.copyCurrentVariableValues(ExecutionPlanContextImpl.java:67)

at com.ddtek.xquery.mediator.xtuple.ExpressionEvaluator.evaluateExpression(ExpressionEvaluator.java:583)

at com.ddtek.xquery.mediator.xtuple.ExpressionEvaluator.evaluateExpressionToValue(ExpressionEvaluator.java:491)

at com.ddtek.xquery.mediator.xtuple.TagSequence._materialize(TagSequence.java:66)

at com.ddtek.xquery.mediator.xtuple.Sequence.materialize(Sequence.java:125)

at com.ddtek.xquery.mediator.xtuple.Sequence.getValue(Sequence.java:148)

at com.ddtek.xquery.mediator.plan.ExecutionPlanContextImpl.copyCurrentVariableValues(ExecutionPlanContextImpl.java:67)

at com.ddtek.xquery.mediator.xtuple.ExpressionEvaluator.evaluateExpression(ExpressionEvaluator.java:583)

at com.ddtek.xquery.mediator.xtuple.ExpressionEvaluator.evaluateExpressionToSequenceIterator(ExpressionEvaluator.java:507)

at com.ddtek.xquery.mediator.plan.SaxonSourcePhysOpImpl.execute(SaxonSourcePhysOpImpl.java:185)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:108)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.ReturnPhysOpImpl.getNextSequenceUngrouper(ReturnPhysOpImpl.java:105)

at com.ddtek.xquery.mediator.plan.ReturnPhysOpImpl.next(ReturnPhysOpImpl.java:62)

at com.ddtek.xquery.mediator.plan.ExecutionPlanImpl.next(ExecutionPlanImpl.java:301)

at com.ddtek.xquery.mediator.plan.DefaultPlanIterator.getAsXQueryStreamReader(DefaultPlanIterator.java:109)

at com.ddtek.xquery3.xqj.layer.DDXQResultSequence.getXQueryStreamReader(DDXQResultSequence.java:577)

... 1 more

Caused by: com.ddtek.xquery.jdbc.base.BaseBatchUpdateException: [XQuery][SQLServer JDBC Driver]IO Error writing temp file: There is not enough space on the disk

at com.ddtek.xquery.jdbc.base.BaseStatement.executeOneStatementAtATime(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseStatement.executeBatch(Unknown Source)

at com.ddtek.xquery.extractor.sql.generic.SqlGlobalCollection.RunSqlBatch(SqlGlobalCollection.java:1098)

... 193 more
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 19 Aug 2008 04:07 PM
Hm, interesting; that's an error triggered by the underlying JDBC driver. The drivers attempt to create temporary files using the location specified by the Java system property "java.io.tmpdir".

So, if you are running it from inside Stylus Studio, you'll need to bring up the Tools > Options > Java Virtual Machine page, and add something like...

-Djava.io.tmpdir=c:/mytempfolder

...to your JRE parameters.
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 19 Aug 2008 04:22 PM
uh oh.
tried that (set up a temp folder in the JRE parameters like so:

-Djava.io.tmpdir=G:/TEMP

and now I can't get Studio to launch (keep getting that whole 'had to close... error report' sequence).

is what I just added stored in a file I can get to?
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 19 Aug 2008 04:30 PM
In the registry:
HKEY_CURRENT_USER\Software\Stylus Studio\2008 XML Enterprise Suite Release 2\Runtime Settings

The affected value should be "JVM Args".

Can you copy and paste that value here before you remove the offending entry? A similar option doesn't seem to negatively affect my Stylus Studio copy.
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 19 Aug 2008 04:43 PM
operator error operator error...

being severely Java challenged, I misunderstood the delimiters and put [,-D] at the end instead of [ -D]... regedit fixed...

now I'm getting java heap errors... which previously has meant I was trying to pull too many records at once. So I took it down from 1000 to 100 on the group size, but still getting the same problem.

*****************************************************************

java.lang.OutOfMemoryError: Java heap space

at com.ddtek.xquery.jdbc.sqlserver.tds.TDSConnection.getReaderBuffer(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserver.SQLServerByteOrderedDataReader.receive(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserver.tds.TDSRPCNonCursorExecuteRequest.submitPrepExec(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserver.tds.TDSRPCExecuteRequest.doPrepExec(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserver.tds.TDSRPCExecuteRequest.execute(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.ddtek.xquery.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at com.ddtek.xquery.extractor.resultset.JdbcPreparedStatement.execute(JdbcStatement.java:466)

at com.ddtek.xquery.extractor.resultset.TreeOfTreeResultSets.execute(TreeOfTreeResultSets.java:244)

at com.ddtek.xquery.extractor.resultset.TreeOfTreeResultSets.execute(TreeOfTreeResultSets.java:251)

at com.ddtek.xquery.extractor.ExtractorStatement.executeCurrentTreeResultsetInTransaction(ExtractorStatement.java:283)

at com.ddtek.xquery.extractor.ExtractorPreparedStatement.executeQuery(ExtractorPreparedStatement.java:107)

at com.ddtek.xquery.mediator.plan.SourcePhysOpImpl.executeStatement(SourcePhysOpImpl.java:623)

at com.ddtek.xquery.mediator.plan.BatchSourcePhysOpImpl.execute(BatchSourcePhysOpImpl.java:187)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:106)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.generateNextXTuple(BatchJoinPhysOpImpl.java:89)

at com.ddtek.xquery.mediator.plan.JoinPhysOpImpl.next(JoinPhysOpImpl.java:92)

at com.ddtek.xquery.mediator.plan.ProjectPhysOpImpl.next(ProjectPhysOpImpl.java:74)

at com.ddtek.xquery.mediator.plan.JoinSaxonSourcePhysOpImpl.next(JoinSaxonSourcePhysOpImpl.java:103)

at com.ddtek.xquery.mediator.plan.BatchJoinPhysOpImpl.fillBatch(BatchJoinPhysOpImpl.java:140)

*****************************************************************

Back when I ran it with the -10 to -1 where clause in place, it ran fine (except that each file was the same 10 records). Attached is my current xquery file...


Documentbig.xquery
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 19 Aug 2008 04:52 PM
The error seems to be still happening at the JDBC level; I'm not sure that will help, but can you try boosting your JVM heap settings a bit? In the same field where you have the temporary folder setting, also add: -Xmx512m
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 19 Aug 2008 05:19 PM
can't seem to squeeze 512 in, I have it up to 468, but I'm still getting heap errors...
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 19 Aug 2008 05:29 PM
We will need to run some experiments here simulating your DDL and XQuery; we'll be back with feedback or questions as soon as possible.
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 19 Aug 2008 06:06 PM
aye, thank-you for the help.
Looks like I may have found something that heads towards a solution. What I have done is to reduce the size of the driving table (singles) by pulling the Abstracts into a separate table. I also reduced the size of the group (it's at 100 right now, and I should be able to bump that back up now). I think the main offender (hitting the heap) was the varchar(max) field for the abstracts. Going to let this run for a few hours, then modify the parameters a bit and try again (would prefer not to have 4,770 files if I can help it).
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 20 Aug 2008 08:26 AM
If you have a column with very large content, that would also explain the I/O out of space error you initially got. And would likely explain why you are running out of heap space; in the current release, serialize-to-url will instantiate in memory the fragment that it needs to serialize (one by one); if each individual segment is large, you'll end up hitting the problem you are describing.

The workaround would be to not use serialize-to-url and return a sequence of XML fragments as result; and then to stream them to file(s) through the XQJ API. As long as you have a valid DataDirect XQuery license (Stylus Studio grants you evaluation rights to such API for 14 days after installing the application), you could try using the attached query and ask Stylus Studio to generate the Java code for you (XQuery menu). Change the XQuery execution line to save the result to a file, from:
xqExpr.executeQuery().writeSequenceToResult(new StreamResult(outWriter));
...to...
xqExpr.executeQuery().writeSequenceToResult(new StreamResult(new File("c:/huge.xml")));


The generated sample app will create a single very large file (not well formed; it will have multiple document elements), but that would be a start to see if that would solve heap space issues.


Documentmodified.xquery
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 20 Aug 2008 01:42 PM
I'll give that a try once I get the overall transformation nailed down. Speaking of which, I'm still having some difficulty with empty nodes. Keeping the empty elements from appearing is working great, where I'm having problems is with sequences. See attached. When I structure it like:

for $TA in collection("xAce.dbo.TA")/TA
where $singles1/autoID = $TA/autoID
return
<TaxonomicData>
<Taxonomic>
{
$TA/TA/text()
}
</Taxonomic>
</TaxonomicData>
}

it's not present when empty, but when it has data, the xml is not structured like I want. I get:

<TaxonomicData>
<Taxonomic>data</Taxonomic>
</TaxonomicData>
<TaxonomicData>
<Taxonomic>data</Taxonomic>
</TaxonomicData>

rather than:

<TaxonomicData>
<Taxonomic>data</Taxonomic>
<Taxonomic>data</Taxonomic>
</TaxonomicData>

however, if I build it like:

<TaxonomicData>
for $TA in collection("xAce.dbo.TA")/TA
where $singles1/autoID = $TA/autoID
return
<Taxonomic>
{
$TA/TA/text()
}
</Taxonomic>
}
</TaxonomicData>

it looks great when there is data, but I'm back to empty elements,

<TaxonomicData />

when there is no data. How do I wrap another conditional around the entire sequence?


Unknownsample(11).xml


Unknownmapped.xquery
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 20 Aug 2008 01:53 PM
<TaxonomicData> {
for $TA in collection("xAce.dbo.TA")/TA
where $singles1/autoID = $TA/autoID
return
if ($TA/TA) then
<Taxonomic>
{
$TA/TA/text()
}
</Taxonomic>
else ()
}
</TaxonomicData>
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 20 Aug 2008 02:03 PM
grrrr... thanks.
I think I had that for awhile, but got confused and pulled the inner conditional out somewhere in the wee hours last night...
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 20 Aug 2008 02:37 PM
hmmm, still not working, what is going on?
I put in:

<TaxonomicData>
{
for $TA in collection("xAce.dbo.TA")/TA
where $singles1/autoID = $TA/autoID
return
if ($TA/TA) then
<Taxonomic>
{
$TA/TA/text()
}
</Taxonomic>
else ()
}
</TaxonomicData>

which I think matches what you put,
but still I'm getting:

<TaxonomicData />

when there are no entries...
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 20 Aug 2008 02:51 PM
...that's because you have no rows in the table matching the where condition; so, maybe what you are really trying to do is (I didn't check the grammar very carefully):

let $TAs := collection("xAce.dbo.TA")/TA[$singles1/autoID = autoID]
return
if ($TAs) then
<TaxonomicData>
{
for $TA in $TAs
return
<Taxonomic>{$TA/TA/text()}</Taxonomic>
}
</TaxonomicData>
else ()

...if you can also have empty TA *columns* then things are a bit more complicated:
(: first create a sequence containing all non-null TA column strings :)
let $TAs := for $TA in collection("xAce.dbo.TA")/TA[$singles1/autoID = autoID] return if($TA/TA) then $TA/TA/text() else ()
return
(: if there is at least one non-null TA column value, then create the structure :)
if ($TAs) then
<TaxonomicData>
{
for $TA in $TAs
return
<Taxonomic>{$TA}</Taxonomic>
}
</TaxonomicData>
else ()
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 20 Aug 2008 03:05 PM
ahhh, ok, that is indeed what I needed. The first snippet fixes the problem I was having with the taxonomic data (now I just need to replicate it in the other dozen or so places), and the second snippet looks like it may be good for the other case I have, which is more complicated... I have a sequence that looks like:

<sequence>
<element1></element1>
<element2></element2>
<element3></element3>
</sequence>

the fun part is that each sequence will have either element1 or element2, and if element2, then maybe element3, and of course, each record may or may not have the sequence at all...
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 21 Aug 2008 11:46 PM
OK, got the complete transform done. Now the performance questions. In preview mode, I can pull 10,000 records at a time in ~65 secs. But when I implemented the serial to url automated method, I was reduced to generating 250 record files, each one taking about 10 mins. After letting it run for about 18 hours I had to shut it down and go back to the manual method. Automated was going to take about 10 days (I had maybe 2 available), whereas, while painful, I was able to process all 475,000 records in a bit under 3 hours. Is there a way to improve the automated method? Would the 'really large file' approach you mentioned be speedy? Or would it be possible to set up some kind of external script to can the ranges and pass in parameters?


Unknownmapped(1).xquery


Unknownbig(1).xquery
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 22 Aug 2008 08:23 AM
Both alternatives you are mentioning would likely be much more performant; as I mentioned, serialize-to-url creates an in-memory representation of the document that needs to be created, which likely slows down things dramatically in your scenario.

You can try the creation of the large file through the API - and that should give you a good feeling of what's the real time it would take to process and serialize the whole data set. And you can also use external variables in XQuery and bind them dynamically through Java to run multiple XQueries that take care of your problem.

Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 22 Aug 2008 08:40 AM
can I drive the API with Python?
where do I find docs?
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 22 Aug 2008 08:49 AM
The API is a Java API; assuming you have a standard Stylus Studio Enterprise installation, you can find the following documentation:
- JavaDoc: c:\Program Files\Stylus Studio 2008 XML Enterprise Suite Release 2\Components\DataDirect XQuery\javadoc
- User guide: c:\Program Files\Stylus Studio 2008 XML Enterprise Suite Release 2\Components\DataDirect XQuery\books\ddxquery\books.pdf
- Examples: c:\Program Files\Stylus Studio 2008 XML Enterprise Suite Release 2\Components\DataDirect XQuery\examples
Postnext
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 02 Sep 2008 09:26 PM
haven't had a chance to play with the API yet... however, I have what should be a simple question. For my xquery, I started with a fairly detailed xsd, but over the course of multiple revisions, my target document no longer matches the original. Some nodes no longer mapped, and some new nodes. How do I push these changes back to the xsd file? (or save a new xsd which reflects the current mappings).
Postnext
Minollo I.Subject: Complete SQL Server database transform to XML
Author: Minollo I.
Date: 02 Sep 2008 10:32 PM
You mean you didn't change the underlying target schema, but you changed the target tree in mapper? And you are looking to push those mapper changes into the original XML Schema? That operation is not supported; the target panel in Mapper is meant to display a schema structure and it allows you to augment it, but it's not able to edit the XML Schema itself...
Posttop
Bernard QuinnSubject: Complete SQL Server database transform to XML
Author: Bernard Quinn
Date: 03 Sep 2008 05:15 AM
or generate/document the new effective schema. doesn't need to push back to the original, would be just as happy with a new xsd file.
   
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.