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)
-> + syntax (2)
-> + Problem using mySQL (2)
-> + accessing Javascript variable ... (2)
-> + problem when openning files (2)
-> + Free Form Text (2)
-> + Cant open the database (4)
-> + Problem using MS Access (4)
-> + 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)
-- 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.