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 » Generating XML files accesing a MS SQL Server within a COBOL application
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> - Generating XML files accesing ... (6)
-> ->Generating XML files acce...
-> ->Generating XML files acce...
-> ->Generating XML files acce...
-> ->Generating XML files acce...
-> ->Generating XML files acce...
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> + mySQL DB Connection 2 (10)
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> + Automation using Visual Studio (7)
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] 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
Rodolfo VegasSubject: Generating XML files accesing a MS SQL Server within a COBOL application
Author: Rodolfo Vegas
Date: 06 Jun 2008 07:47 AM
I'm trying to obtain XML files extracting some data from a Microsoft SQL Server and link this this process to an existing COBOL application.

I've developed a XQuery file that extract the data, and also an XSLT Stylsheet that does the same job.

From the COBOL application we can invoke any executable file through a specific call, thus I have tried these 2 approaches:

1) Invoking the command line utilities StylusXql/StylusXslt to execute the Xquery file/XSLT Stylesheet with the appropiate parameters.

2) Include the XSLT in a pipeline and generate C## .NET code to compile it and later invoke the so produced executable.

After several tries on both approaches, I've been finally not able to get to the final goal due to different type of errors and/or limitations of the software.

I'm using a full license of Stylus Studio 2008 XML Enterprise Suite Release 2, build 1147d.

Do you think I should be able to do the task in this way? If not, is there any other way to reach the desired results? Do you recommend any other tools, utilities, to do it?

Thanks in advance.
Postnext
Ivan PedruzziSubject: Generating XML files accessing a MS SQL Server within a COBOL application
Author: Ivan Pedruzzi
Date: 09 Jun 2008 08:18 AM

Hi Rodolfo,

In order to invoke DataDirect XQuery outside Stylus Studio you have to run a java program.

Stylus Studio can generate the code for you, please have a look at the video tutorials

Using DataDirect XQuery® to Access Relational Data
http://www.xquery.com/videos/datadirectxquery/ddxq1a.html

Java Code Generation
http://www.stylusstudio.com/videos/code-generation1/code-generation1.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Rodolfo VegasSubject: Generating XML files accessing a MS SQL Server within a COBOL application
Author: Rodolfo Vegas
Date: 10 Jun 2008 04:45 AM
Hi Ivan,

From your response I assume that invoking the command-line utilities is not a valid solution for this task. Am I right?

You mention the Java code generation. Isn't it also possible to do a C# code generation? I mean, is this a valid solution? In fact, Stylus Studio is able to generate the code and to include it in a new or previously existing Visual Studio .NET project.

I've tried this and I've been able to compile and debug the source code, but when it performs the step where it should access the MS SQL Server database it displays the following error message: "The URI prefix is not recognized."

The URI for the relational database from the MS SQL Server where it's trying to get the data from, stored in the inputUrl constant (as generated by Stylus Studio), has the form "xquery:///jdbc:xquery:sqlserver://ServerNetname:Port;schema=dbo;table=TableName;user=Username;password=073320740D2148;xmlforest=true;DatabaseName=DBName;urltype=.xml"

Am I doing something wrong or is the C# not a valid solution?

Thanks for your support
Rgds,
Rodolfo Vegas
Postnext
Ivan PedruzziSubject: Generating XML files accessing a MS SQL Server within a COBOL application
Author: Ivan Pedruzzi
Date: 10 Jun 2008 05:11 PM

Nope DataDirect XQuery is Java only.

Nope the StylusXQL command line runs the Stylus Studio built-in processor that does not support relational access.

URLs based on the prefix xquery: only work in Stylus Studio.

We do not provide a component to access relational data for XQuery/XSLT under .NET.

You may invoke DataDirect XQuery using its command line but still need to have the Java Virtual Machine installed in your system.

Here the documentation
http://media.datadirect.com/download/docs/ddxquery/allddxq/reference/wwhelp/wwhimpl/common/html/wwhelp.htm?context=Reference&file=quickstart2.html


Ivan Pedruzzi
Stylus Studio Team
Postnext
Rodolfo VegasSubject: Generating XML files accessing a MS SQL Server within a COBOL application
Author: Rodolfo Vegas
Date: 11 Jun 2008 08:29 AM
Originally Posted: 11 Jun 2008 05:18 AM
Hi Ivan

Thank you for clarifying the question. Now I realize that the only way to do the task is Java. It's a pity that the C# for .NET is not supported (nevertheless I still think Stylus Studio is the greatest XML-related software of the world). Are there any plans for adding this support in the near future?

I've tried to execute the DataDirect XQuery command-line utility and I get the message "XQException: [DataDirect][XQuery]The evaluation period for DataDirect XQuery has
expired. Please contact DataDirect Technologies to purchase a valid license. VendorCode: EX0073"

I suppose that using ANY DataDirect XQuery process from outside the Stylus Studio IDE requires a proper license. Am I right? Anyway, that would not widen the possibilities, would it?

We actually have a license for Stylus Studio Enterprise and a license for DataDirect XML Converters. If we bought a license for DataDirect XQuery, would we be able (with the three components licenses) to do just ANYTHING that we actually can do from inside the Stylus Studio IDE? Or are there any other "modules" which may require also a separate license?

Thanks for all your support, help and suggestions.
Regards,
Rodolfo
Posttop
Ivan PedruzziSubject: Generating XML files accessing a MS SQL Server within a COBOL application
Author: Ivan Pedruzzi
Date: 11 Jun 2008 12:47 PM

Hi Rodolfo,

There are no firm plan at this time to have DataDirect XQuery for .NET

Yes, a DataDirect XQuery license is required in order to run queries outside Stylus Studio.

No additional components are required in order to "Generate XML files accessing a MS SQLServer"

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.