Search found 3835 matches

by eostic
Thu Oct 22, 2009 11:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem parsing xml
Replies: 6
Views: 1732

No reason you shouldn't be able to import it.....try to make sure that you have a "fully populated" sample document. If you have the xsd, use any of 100's of tools that you can find on the web or elsewhere to generate a sample document that has all elements and attributes populated. ...or ...
by eostic
Thu Oct 22, 2009 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem parsing xml
Replies: 6
Views: 1732

Well...for starters, QC and Stablity are not attributes...so if that's the xpath you have, you will definitely not get anything....at the very least, I would first try these columns on your output link... SiteXML (check yes for key) /Ext/Site St /Ext/Site/@St Cr /Ext/Site/@Cr QC /Ext/Site/QC/ Stabil...
by eostic
Wed Oct 21, 2009 9:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle xml data of following type '&amp;lt'
Replies: 1
Views: 702

That's because it is likely that's the actual value (meaning -- it is correct). When xml is created, certain characters are "escaped"..this means that they are changed so that they can be represented in the content and not confuse some other parser.... so..... the '&' becomes '&amp...
by eostic
Wed Oct 21, 2009 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem parsing xml
Replies: 6
Views: 1732

Hmm.... that's an interesting problem indeed.....from the looks of things, QC and Stability are "sub-elements" of Site. You should be able to just grab the values for those two elements as columns to be on each row of Site.... QC would have "/Ext/Site/QC/text()" and Stability wou...
by eostic
Tue Oct 20, 2009 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transforming a flat file into XML
Replies: 6
Views: 3673

Are your input link columns and properties on XMLOutput now identical to my post up above? Is your XMLOutput the last stage in the stream? Are you certain that you have access rights to the location where you are writing the file? Are you getting data down the link that goes to the XMLOutput? Ernie
by eostic
Mon Oct 19, 2009 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transforming a flat file into XML
Replies: 6
Views: 3673

..that isn't that easy to read.... start each string in the description property with the /myXML part....

Ernie
by eostic
Mon Oct 19, 2009 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transforming a flat file into XML
Replies: 6
Views: 3673

I agree with Craig...it's not exactly clear what you are looking for, since the output you display, and the description of the objective (so that it can be read by Cognos) are not consistent with needing xml. That being said, for the simple 3 columns you have, just put this in your Description prope...
by eostic
Fri Oct 16, 2009 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error in Web Service Transformer Stage
Replies: 8
Views: 9896

This question depends on the interpretation of "fully web based". In terms of the engine, I agree wholeheartedly with Ray. The core of DataStage needs to handle transactional ("typically" low volume, high speed, "real time") transformation and batch (typically high volu...
by eostic
Fri Oct 16, 2009 8:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RTI & WISD
Replies: 7
Views: 2483

It's not the easiest thing to find, but the feature for "disable" is still there, as it was in RTI..... Open your Information Server Console.... Open your ISD project. Go to the dashboard...find and follow the links there that point to your "Deployed Applications Workspace" (this...
by eostic
Thu Oct 15, 2009 3:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error in Web Service Transformer Stage
Replies: 8
Views: 9896

get yourself a copy of a SOAP testing tool.....(there are 100's on the web)....SOAPBox from Vordel is a good one, as is SOAP UI. There is a thing called the Web Service Explorer in RDA/IDA/WID/RAD/RSA and most of the Rational Eclipse based tooling....... make sure you can get the service to function...
by eostic
Thu Oct 15, 2009 3:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Best key candidate for datastage XML export
Replies: 2
Views: 1921

You will have MANY keys..... the "key" is a "repetitiion element". For "each node path", it represents a column at the "desired bottom" of your retrieval for that node path --- in other words, a "row" that you would like to have retrieved (as if a &q...
by eostic
Wed Oct 14, 2009 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling XML element tags
Replies: 3
Views: 1326

"Note" is a parent element containing sub-elements...it need not be retrieved....it has no text....the only columns are "to" "from" "heading" and "body" ...they are 'defined' by their parent, Note..... you could change the column names to NoteTo and ...
by eostic
Wed Oct 14, 2009 1:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Designing DataStage jobs as services
Replies: 4
Views: 5547

QualityStage changed significantly in v8 --- it becomes essentially a function (or "stage") in a flow of a DataStage Job.....and then you build the flow to support ISD and Services as noted above. Your rule sets will migrate to 8.1 -- I don't recall off hand whether the conversion utility ...
by eostic
Wed Oct 14, 2009 12:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling XML element tags
Replies: 3
Views: 1326

scroll to the right on the link... add "text()" to the end of each of the strings....

Ernie
by eostic
Tue Oct 13, 2009 1:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in reading response from MQ
Replies: 11
Views: 5104

Are you getting a clean xml document now? You noted above that you have "one" xml document per message...but the symptoms that started this thread sound otherwise, or that maybe the xml documents are (potentially) huge and split across multiple messages, perhaps with things like correlatio...