DSXchange

Hi Lance... I haven't yet seen any need for it.......a few years ago I took a look at each of the major vendor's implementations (of their xml storage capabilities, their support for xquery and other xml in support of embedded xml documents in xml datatype columns, etc.), and they all seemed to have...

Late reply. Been on a long plane ride from Asia.... IBM is working on it, but we have a another quarter or two to wait. We're seeing more and more large XML...... In the meantime, you would need to break it up...I've seen people do it creatively in java, or using something like XMLMax (Windows based...

Hmm.... If I understand the issue, it would appear to simply be that the first XMLOutput Stage is creating a fully valid and normal document, and then the next XMLOutput Stage is "wrapping it" again inside of another normal document...... If that's the problem, look at the settings in your...

Thanks for sharing! You never know when you need a special technique or tool in a new or strange environment!

It's very cool. I had the pleasure of doing some beta testing with it.....it works great....took a little getting used to at first (mostly conceptually as you set up the instances and IP addresses thru their gui's)-- you become your own "administrator" and configure and start stuff, and th...

Yes... I haven't done it with the new DTS (this is an old technique that works for MQ plugin in server jobs with "similar" concept and flow), but it is designed in that fashion.... ...the key is in the source MQ Connector....you provide a "work queue"....the message is moved to t...

Great work...glad you are able to retrieve the data. Now you can use this example to learn more details about the XMLInput Stage. The Repetition Element (key=yes) is not a "key"....it is simply telling the xmlInput Stage the deepest level that you are interested in retrieving (the one whos...

My suggestion then, is to use the MQ Connector. It supports MQ client out of the box, and is ready to go. Be sure that you have the MQ Client software working perfectly and able to connect to MQ, write and read messages, etc. before you get into DataStage. Spend time with the documentation for the C...

Couple of things to consider and try: a) Are you planning on using MQ Client or MQ Server (is the MQServer co-resident with DataStage?) b) Depending on that choice, do you recall what choices you made when Information Server was installed? It asks if you want the MQ plugin and then asks if you want ...

Ok. Can you share the same chunk of xml with us...but copy it from the actual file you are reading and not from a display in IE? (it's unlikely that the embedded xml would look like this while on the wire --- the internal xml document usually would be "escaped"...meaning that it will have ...

check out the examples at my blog below....table of contents in the upper right...look for info on integrating java with DataStage.... ...and search this forum...there are several of us that work with java and DataStage a lot and have thoughts and answers to other threads.... Your JavaClass interact...

Craig...you are too funny. Indeed, Craig is right, the "key" is nothing more than an indicator for the repeating level that you want to retrieve. There are no keys --- just instances of elements. Each "independent" repeating node (or deeply nested set of nodes) must be on its own...

How big is it? 20k "rows" from this is not that much...are you saying that there are simply 20k customers in this one single xml document, or 20k "documents" that you are reading from disk initially (each with their own set of customer elements)?

Ernie

I've only used it in conjunction with MQ and an rdbms.... can you describe your ultimate objective?

Ernie

Here are things to try: a) Assuming this is a clean file you can review in something like notepad (as opposed to the display of xml below that looks like it was copy/pasted from IE), import it into the XML importer. b) check only one column....the lower level "T" box for xmlData. Mark it a...