DSXchange

If you ever wondered what Information Services Director is, or need a quick refresher on how to publish a DataStage or QualityStage Job as a Service, check out this link at YouTube... http://www.youtube.com/channel/UCVFAoFT_zaVF_JWHGz-8d5w?feature=guide Not trying to simply make a "plug" f...

...and if it's a memory issue, then start looking at things like: a. does it only fail with "this" particular xml document? (is it big?) b. does it fail with ANY document? (even tiny ones) c. if it's just "this" document, how big is it? anything special about it? particular nodes...

Hi Richard... Welcome to the world of xml and DataStage! DataStage looks at repeating nodes as you describe as a "set" of "child values" potentially related to a particular parent. This is no different than a 1:many relationship between tables in an rdbms, or the repeating group ...

Metadata Workbench can tell you some of this.....it will find all the Jobs that use a particular Job Parameter (or Parameter that is a member of a Parameter Set).

Ernie

Just be careful and be sure to document its location for yourself or your internal support team....that location is likely to get blown away when you apply a patch.... There are several of those that you can use -- the key is in understanding the web root.....(internally in a web server, there is a ...

...thanks for the memories, lstsaur! Indeed, RTI in production offered a WSDL that basically wrapped the classic Job Control API. Accessing the new Ops Console remotely from my BB is one I haven't tried........don't know what kinds of browser requirements it has. I'll have to put that one on the lis...

Great, Aaron! I will try to be there.....

The Ops Console is very cool, folks --- don't miss this one.

Ernie

Not sure exactly, but it's possible that a Server Job and the Folder Stage will work....it lets you dictate filenames by a column value.... For the xml Output Stage, the trigger that you are using will release individual documents to the output link if you create one. Add an output link and put one ...

Perhaps, but it's ugly and we ought to start a campaign to change it.

The Stage only works when the name of the xsd is "in" the header....after you read the payload from MQ, run it thru a transformer and "zap" the correct xsd into it. If you are using xmlInput, that's the only way to do it. If the messages are not "too" big, it should be ...

The validation is done via the xmlInput Stage, or, if you are on 8.5.x or 8.7, with the xml stage.....in the former, the xsd is stored somewhere on the DataStage server and pointed to within the header of the incoming document (it's "possible" the it may find the xsd via url, but there wer...

In 8.5 IA introduced a REST-like API. That's your best method to access results from IADB. I haven't used it much except to play with it initially, but I've talked to people who have done some very cool things with it. Here's a primitive "template" example that one of my colleagues wrote.....

Congrats! It takes a little getting used to, but basically, this is exactly what you need to do in order to tear apart any form of hierarchy. Turn it into the "rows" that it might be if the source XML were instead just a big collection of relational tables with some common keys (the higher...

This new error has nothing to do with repeating elements.... check out this entry and then use the External Source stage to read your file... http://dsrealtime.wordpress.com/2007/12/04/reading-xml-content-as-a-source/ ...and if you are using an intermediate flat file between jobs, be sure to use NO ...

This doesn't tell us enough to help. Create another Job. Have just "one" link coming from your xmlInput Stage. Send it to flat file. Make sure that link is retrieving a particular single repeating node (and its parents) correctly. Then proceed to create another link for any other lowest le...