Search found 3835 matches

by eostic
Mon Mar 11, 2019 7:59 am
Forum: General
Topic: Writing HTML using DataStage
Replies: 3
Views: 3437

Haven't tried this, but the closest I think you might get is to look at the various XML Stages --- xml Input, xmlOutput and the xmlTransformer. Each of these has the option to include XSLT --- and then adjust output "however you want". It requires that you have extensive knowledge of XSLT ...
by eostic
Wed Feb 27, 2019 3:24 pm
Forum: General
Topic: Inputs/loading a SOAP webservice with multiple complex types
Replies: 5
Views: 4437

:) same concept in reverse, assuming that the body is also a complex xml doc. Put one big column on the output link.....like "mySOAPresponse" longvarchar and put a single "/" (slash) in the Description property. No other cols. Then use the same "user dfined message" pul...
by eostic
Mon Feb 25, 2019 2:48 pm
Forum: General
Topic: Inputs/loading a SOAP webservice with multiple complex types
Replies: 5
Views: 4437

Look at the special property in the input link for "user defined" message. Have that point to the single large varchar column that you built upstream with the whole payload. ...and the best thing to do is to first test this by: 1. run your service via SOAPui or other tool. 2. copy a workin...
by eostic
Mon Jan 28, 2019 6:18 am
Forum: General
Topic: Inputs/loading a SOAP webservice with multiple complex types
Replies: 5
Views: 4437

More difficult. For this you need to build thr entire soap payload yourself... the web services transformer isnt able to build a complex multi node independenly repeating xml payload. It can be built upstream via multiple xml output stages or via the hierarchical stage. Both require testing and lear...
by eostic
Tue Jan 15, 2019 9:04 am
Forum:
Topic: IGC environment approach
Replies: 6
Views: 4483

Great discussion. It is worth noting also that a lot of sites will have a separate instance of Information Server for IGC and governance activities. This is primarily because the upgrade effort to get the "latest GUI", etc. is often not as exhaustive as upgrading/testing all of your DataSt...
by eostic
Mon Jan 14, 2019 4:22 pm
Forum:
Topic: Why would you restrict access to terms in the Glossary?
Replies: 6
Views: 4656

Nice solution!
by eostic
Mon Jan 14, 2019 4:15 pm
Forum:
Topic: IGC Application asset type
Replies: 3
Views: 3395

Not sure at this point what is on the agenda.

Ernie
by eostic
Fri Jan 11, 2019 4:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Design XML(multiOccurance) using Hierarchial Data stage
Replies: 5
Views: 4874

Looks like a classic poorly designed xml. Better would have been to have an actual element called "<StartDate>" and another called <EndDate> and populate them appropriately. For something like this, just build the little xml chunk in a transformer and include it in the Description property...
by eostic
Thu Jan 10, 2019 2:14 pm
Forum:
Topic: IGC Application asset type
Replies: 3
Views: 3395

They work nicely, and provide an easy way to extend the repository, albeit not as elegant as OpenIGC.

Ernie
by eostic
Fri Jan 04, 2019 7:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Design XML(multiOccurance) using Hierarchial Data stage
Replies: 5
Views: 4874

Based on this kind of straight path hierarchy, I would use xml output and skip the hierarchical stage. You dont need it. It only makes sense when you have parallel siblings to produce for a given order, such as maybe multiple purchasers. There may be other variables in your requirement but so far, x...
by eostic
Sun Dec 23, 2018 3:48 pm
Forum:
Topic: Importing non infosphere metadata into the Metadata Workbenc
Replies: 6
Views: 4100

Perfect for OpenIGC. See the toc at www.dsrealtime.com
by eostic
Sun Dec 23, 2018 8:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: hierarchy xml stage
Replies: 2
Views: 3363

Not sure if or how the hierarchical stage decides. In the xmloutput stage you have a choice. Either way, it doesnt matter. Both are the same. You might want to check to see if validation is on.

Ernie
by eostic
Thu Dec 20, 2018 7:24 am
Forum: General
Topic: Need Plugin to connect InfoSphere Data Architect and TFS
Replies: 4
Views: 4545

Team Foundation Server ...is that another Source Code management system? I haven't ever heard of that one, but perhaps it is another Eclipse based offering that "perhaps" IDA could connect to? I am not an IDA expert and don't follow it closely, so maybe something was done formally, but if ...
by eostic
Fri Dec 07, 2018 1:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML DATA from hierarchy stage
Replies: 4
Views: 4099

Using xsi:nil is the "deeply specific" way to declare that a particular xml element is a "null" value. One of the reasons it was put into the standard is that there is no real way to tell if <element></element> means "blank"?...or does it mean NULL? The Hierarchical Sta...
by eostic
Tue Dec 04, 2018 4:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchy stage <element/> tags
Replies: 4
Views: 4185

This is a good discussion.... XML, as a standard ,supports two similar methods for indicating an "empty" element. <element/> and <element></element> Both are entirely equivalent --- the mean the same thing. Some have argued in the past that one is more readable than the other...and certain...