DSXchange

(it can be installed afterwards, but it's easiest if you pick it initially).

Ernie

Assuming that you already have a license for MQ (either for the MQ client or MQ Server) installed on your DataStage machine, you don't need anything added to DataStage ----- however, you do need to make a decision at Info Server install time that you want to use MQ, and then also if you expect to be...

There are so many things that this could be.....from a problem in your java class to some memory issue somewhere....or maybe another Stage and it just "looks" like it is an issue in your class.....hard to tell. A very interesting test would be to see if it hangs consistently also in a Serv...

The CDC Stage has been around for a long time, and is a key way of comparing sets of data, sometimes which are quite large. InfoSphere CDC is the name for the collection of modules that perform log based changed data capture from mainframe databases, other rdbms', etc. Some of it represents former D...

Yeah...go for it. I don't think it's copyrighted material, and I'm sure Hernando would ultimately appreciate it too. It's too subtle an issue to make a big deal about...I'd just edit the job as is and zap it into the zip.......I don't have time to check every other example, but at least we'll know t...

Thanks Colin! Good to hear it was resolved. It raises some interesting questions and discussions.....on "default namespaces" in particular. The defns drives most people crazy. It's not used that often --- I see it maybe 10% of the time. For those who don't know, the default namespace is on...

Hi Colin... I don't.... but I live and breath "almost" exclusively with our xml and metadata related technologies in most of my efforts to support customers, partners, and my IBM colleagues. I'm surpised we haven't met in the past (Ascential and earlier) but your name is familiar.... Ernie

....I'm not talking about the xsd. The key here is in the incoming document itself. A "formally" null element in XML contains the xsi:nil="true" attribute. In the document. It is possible that "formal" xsd validation will only fail if that attribute is present. Otherwis...

It's hard to say...as you can see from various threads here, 8.0 broke xml in many places. Most have have been fixed, but..... Calling support is not a bad idea [many times they call me right afterwards.... ; ) ]. They may have an angle that I haven't yet heard.

Ernie

Something is up......I ran it in 8.1 FP 1 and I don't get any rows at all.....I suspect it is something with the namespace and will check it out. In the meantime, the technique of taking a chunk and then parsing it out further is something that is done in (probably) thousands of jobs since XMLPack 2...

...exactly. Stop sending the "contents" and send just the fully qualified "name" of the document into the stage..... ....the cat is doing something strange, or another intermediate stage is doing something strange, or it's a combination of cat/another stage/and some strange chara...

The newer InfoSphere Changed Data Capture offerings pull a lot of this together nicely nowadays....prior there are many CDC options....Rep Server...Queue Rep....etc, and many of these are integrated directly to DataStage thru a custom Stage type, or at least easily by way of .csv or alternatively, x...

I'd have to check the w3c spec in detail, but it wouldn't surprise me if an "emtpy" element is not considered formally null by the xerces/xalan (apache) parser and processor. I suspect that it's possible that a truly "null" element (for xsd invalidation purposes) would have to ha...

It should be fairly obvious. Look at the XMLInput Stage's output link for this particular address column. If the "chunk" still has tags around it, then it is likely that the ".../text()" is missing from the end of the string that you will find in the Description property for that...

Craig is right --- there are lots of ways to do comparisons in DataStage....nevertheless, convert the column into a normal character field before writing it out. When you are looking at it in DS you are probably using "View Data" which unpacks it temporarily for your viewing....you need to...