DSXchange

I'm still also confused by what you really are trying to accomplish. Copy a chunk of the "actual" xml into a post... it may be more clear for us then. What I "think" you may be referring to is how to connect the output of multiple B rows and then the multiple C rows? Each has to ...

Look again... you should find a variety of entries on using JavaPack to do this. Look also at my blog below...I illustrate a few ways to use JavaPack, and others have entered great info into this forum on JavaPack also. There are lots of considerations, but the first is "how to use a java class...

Your description is still too generic. Can you be more specific.... so...when you test with a sample XML document.... it works? it fails? not sure which you are saying? What are your settings in the XMLInput Stage? What methods (in server and in EE) are you using to "read" your xml documen...

Hi DSDexter... DataStage and the XMLInput stage most certainly can handle this circumstance....but it requires that you carefully review your nested child-parent-grandchild (and so forth) relationships, and then get to know the meaning behind, and behavior of, what is call the "Repetition Eleme...

Sounds pretty shocking to me. I don't know for sure, but WebSphere TX is a significant part of WebSphere Message Broker.... I'd be awfully surprised, and besides, end-of-life needs a lot of time, and TX is still actively selling........ sounds like an error in naming.

Ernie

Bummer that you are getting the error, but great that you are giving it a try. The package tooling is evolving so that it will support a whole lot of Information Server metadata and ultimately be the way to move the entire Info Server domain and not just Job artifacts.

Ernie

Use ISD or RTI and easily have a front end Web Services client application send up the Job parms!

Ernie

JavaPack makes it a lot more elegant, as you can directly interact on a row by row basis with your class. I have a more detailed entry on the subject in my blog below, but basically, DataStage gives control to your class when it (DataStage) needs a row (if your java stage is a source) or when it (Da...

To Sanjay's question "is it better to read XML from a database"..... I'm not sure it's an issue of "better or not".... For all of us in the transformation world, we're usually dealing with whatever is laid in our lap. We simply have to read it from "wherever it is" (and...

...I'm not big on plugs, but if you are looking for some more good reading about XML and DataStage, check out this new article that several IBM XML experts wrote about pureXML and DataStage.... it's new on developerWorks.... http://www.ibm.com/developerworks/data/library/techarticle/dm-0908datastage...

Please start another thread, and in there please be more explicit. When you are sure you have "one" row from the first file, and three rows from the second in a small test, describe what you are doing in the Lookup and how many rows you receive from that lookup.

Ernie

Craig is correct --- you certainly don't need to put it into multiple lines for DataStage's benefit --- in fact, you WANT to send XMLInput a single large column if you are interested in parsing out the elements and attributes. On the other hand, if you are simply interested in writing it to disk, le...

You can have many, many output links from a single XMLInput Stage. This assumes that you would have a single output link for each of the different independent nodes that you are trying to retrieve from (unique repeating elements). Start adding them back to one of your Jobs that works, to see if you ...

This is why I need you to tear it apart. Start from the beginning....it's something happening "in combination"...it's probably not as simple as the syntax of any one link. That's why we need to look at each individual piece. It's impossible to know what might be going on in a more complex ...

Then look at the xml itself. Carefully review the data and what is inside each of the elements? Are there unprintable characters? Create a stand alone test file that has only one main element in it that repeats. Does that work? (something like:) <?xml version="1.0" ?> <myxml> <mydetail> <i...