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 » Connection to DB2 UDB
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Disabled Watch and Variable Vi... (4)
-> + Accessing Filemaker DB via ODB... (2)
-> + About XML Graphs (2)
-> + Error when generate java bindi... (2)
-> + Formatting a number to always ... (2)
-> + Bug with graphical mapper (2)
-> + Back Map to XML does not work (2)
-> + Floating Instruction Graphics (2)
-> + Mapping XSD (4)
-> + Output has dashes (Hyphens) th... (7)
-> + Fwd: Error Message (2)
-> + Error Message (5)
-> + EPG XML Generation (2)
-> - Connection to DB2 UDB (8)
-> ->Connection to DB2 UDB
-> ->Connection to DB2 UDB
-> ->Connection to DB2 UDB
-> ->Connection to DB2 UDB
-> ->Connection to DB2 UDB
-> ->Connection to DB2 UDB
-> ->Connection to DB2 UDB
-> + Instructions In Mapper (6)
-> + using oracle's orcl:right-trim... (2)
-> + xsl fo, generate links in pdf... (3)
-> + Documentation (annotations) in... (4)
-> + Linking to RDBMS to Applicatio... (2)
-> + Stylus build 653c // Metainfor... (3)
-> + namesspacing external entities (6)
-> + Suppress namespace on every no... (5)
-> + xpath: how do I get what I wan... (6)
-> + Still can't remove SS!! (2)
-> + Convert to XML (3)
-> + EDI Error (10)
-> + (500) internal server error wh... (2)
-> + Space formatting with   (4)
-> + UDDI Browser and WS Call Compo... (4)
-> + cursor weirdness (2)
-> + Open XML files in IE, edit wit... (3)
-> + Generate XML from schema (2)
-> + Line-oriented region problem i... (4)
-> + Using local DB2 database Alias... (2)
-> + Small but annoying display bug... (3)
-> + Blank values in lookup lists (11)
-> + xsd problem in mapper (2)
-> + Deployment License (2)
-> + XML post and web service (2)
-> + Stylus just wont start? (2)
-> - Can'rt remove SS from Windows ... (1)
-> + SenseX stops working on second... (4)
-> + dodgy(non-ascii) characters ca... (8)
-> + Optional values (ZZ1) causes e... (3)
-> + Have problems with displaying ... (9)
-> + Can Stylus Studio be used to m... (3)
-> + Erratic behaviour in EDIFACT a... (2)
-> + Year Calculation (2)
-> + How to ouput a real XLS (3)
-> + EDI 856 to XML - java.io.IOExc... (3)
-> + Problem transform EDI to XML (... (2)
-> + SS becomes unusable... (6)
-> + SS Enterprise 735f under WinXP... (7)
-> + Call Web Service, Nothing retu... (12)
-> + Error while debugging xslt wit... (2)
-> + DESADV D96A Schema vs XML inco... (4)
-> + Das Programm mit mysql ? (4)
-> + RegEx Search and Replace (6)
-> + SequeLink Server - Do I need a... (6)
-> + faultString: (401)Unauthorized... (7)
-> + Previewing XSL with javascript... (2)
-> + removing formating from XML (6)
-> + removing formating from XML (2)
-> + Custom EDI to XML conversion (2)
-> + Getting "Type not found" error... (4)
-> - Converting file and customize ... (1)
-> + formatting problem with xml ex... (2)
-> + Using DTD Entities and XSD (7)
-> + XML Schema (XSD), Adding comme... (2)
-> + DTD schema generation problem (2)
-> + How do i generate a schema fro... (4)
-> + Incomplete request message gen... (2)
-> + Installation issue for Stylus ... (2)
-> + DTD "ANY" isn't honored by val... (2)
-> + Replacing carriage returns wit... (3)
-> + WS with SOAP - problem with pa... (5)
-> + problem converting CSV to XML (2)
-> + validating xml with multiple s... (4)
-> + SOAP problems ! (2)
-> + mapping csv columns to schema (2)
-> - Access DB to XML doc using an ... (1)
-> - DataDirect SequelLink w/MS Acc... (1)
-> + Problem with DB to XML Source ... (3)
-> + problems to work from the comm... (3)
-> + Stylus Studio Enterprise WScal... (4)
-> + Erratic behaviour in EDIFACT a... (14)
-> + XML Pipeline Question (7)
-> + Stylus Studio reports invalid ... (4)
-> - Is there a way to generate a G... (1)
-> + Stylus produced XSLT not trans... (2)
-> + XML Editor spell check - bug w... (4)
-> + API unlocks OK, but fails in n... (4)
-> + EDI to XML conversion for UNOC... (11)
-> + Stylus crashed with recurence ... (2)
-> + terrible perfomance using the ... (4)
-> + XSD to RDBMS, e.g. SQL Server,... (3)
-> + relational database (7)
-> + Stylus Studio 6 wrongfully det... (6)
-> + Having trouble with schema val... (5)
-> + Stylus Studio 2007 Home Editio... (2)
-- Previous [1681-1700] [1701-1720] [1721-1740] 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
Jasbir LutheraSubject: Connection to DB2 UDB
Author: Jasbir Luthera
Date: 12 Mar 2007 03:37 PM
I am gettting the following error message when I try to create DB to XML Data Source:

java.sql.SQLException: [StylusStudio][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009

at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)

at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)

at ZC.jdbc.jxtr.JXTRDriverDatabaseMetaData.getTables(Unknown Source)

at com.stylusstudio.DataDirectStub.getSchemas(DataDirectStub.java:1180)
Postnext
Ivan PedruzziSubject: Connection to DB2 UDB
Author: Ivan Pedruzzi
Date: 12 Mar 2007 04:57 PM

Hi Jasbir,

Which Stylus Studio version are you running?

To which DB2 version are you trying to connect?

Rather then using Sequelink, you should be able to use the native DB2 driver.

Are you using the DB to XML Data source or File Explorer -> Relational DB?




Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Jasbir LutheraSubject: Connection to DB2 UDB
Author: Jasbir Luthera
Date: 12 Mar 2007 07:01 PM
Thanks for getting back to me. Okay - lets change the direction, I tried using native connection to db2. I get to fill the following URL:

//localhost:50000;locationName=;collectionId=;packageName=

I know what is localhost, I know what the port is. But, for the life in me, I just can't figure out locationName, collectionID, and packageName. When I did a search at the webesite, it came up with JDBC documentation. Browsing that, it seems these are irrelevant; perhaps not.

Please advice.
Postnext
Jasbir LutheraSubject: Connection to DB2 UDB
Author: Jasbir Luthera
Date: 12 Mar 2007 07:03 PM
I am using the latest version Build 735f (downloaded it yesterday). It is fully registered Enterprise version.

Connecting to db2 on linux box, db2 version 8.2.5
Postnext
Jasbir LutheraSubject: Connection to DB2 UDB
Author: Jasbir Luthera
Date: 12 Mar 2007 07:12 PM
Okay - so I typed the following:

//hostname:90004;databaseName=TESTDB

I get the following error:

[StylusStudio][DB2 JDBC Driver]Unsupported VM encoding Cp500.
Postnext
Jasbir LutheraSubject: Connection to DB2 UDB
Author: Jasbir Luthera
Date: 12 Mar 2007 08:06 PM
Okay - so I got rid of the cp error message above by installing jre (1.6) with international support. But, with the same connection URL specified above, I get the following error:

[StylusStudio][DB2 JDBC Driver][DB2]PROGRAM NAME DEFAULT.DDTEKA 0X4A44424334444232 NOT FOUND IN PLAN null
Postnext
Ivan PedruzziSubject: Connection to DB2 UDB
Author: Ivan Pedruzzi
Date: 12 Mar 2007 10:16 PM

Please try the following.

//hostname:90004;databaseName=TESTDB;packageName=JDBCPKG;CreateDefaultPackage=TRUE


Ivan Pedruzzi
Stylus Studio Team
Posttop
Jasbir LutheraSubject: Connection to DB2 UDB
Author: Jasbir Luthera
Date: 13 Mar 2007 11:50 AM
Finally got it to go. Thanks for your guidance.

Can these steps be integrated into online or online demo? It will make it easier for future reference and easier for new users to get going.

Thanks again.
   
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.