Search found 3835 matches

by eostic
Tue May 28, 2013 5:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WebService Repeating Elements
Replies: 1
Views: 1039

You'll need an xmlOutput Stage prior to the web services transformer. ...one that builds this xml that is required going into the web service, where your multiple ID rows become multiple instances. I recently outlined the steps needed for another poster in the past day or two....search for that and ...
by eostic
Mon May 27, 2013 9:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Web Service Call from DataStage
Replies: 6
Views: 4513

To get two repeating nodes you need two incoming rows. Pivot the addesses first.
by eostic
Mon May 27, 2013 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Web Service Call from DataStage
Replies: 6
Views: 4513

You need to put the xmlOutput stage in front of the ws transformer.... You may have to learn about the xml output stage and build the exact payload required......but if the incoming array is already defined in the wsdl, you can do this easily......put a transformer directly in front of your ws trans...
by eostic
Mon May 27, 2013 11:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error: Xalan fatal error Expected entity name for reference
Replies: 8
Views: 5729

Check carefully also how you are reading it....you should be using the folder stage to pick up the document. ---- if you are using the sequential Stage it is possible your job fails because of a stray CRLF in the midst of the document.

Ernie
by eostic
Fri May 24, 2013 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create XML Document with Multiple Repeated Elements
Replies: 6
Views: 3073

You can do this with the older xmlOutput Stage, but it takes multiple iternations within the job, where you create each repeating node and then put them all together.......search the forum here for threads pointing to Kim Duke's site where you will find an invaluable document on XML Best Practices.....
by eostic
Fri May 24, 2013 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML stage - challenge
Replies: 4
Views: 1866

Both solutions are correct......and the technique is "conceptually" the same. Using xmlOutput Stage, this has to be done in three or more separate Stages....first create the address repeating node.....then on another set of links create the phone numbers repeating node...then store one of ...
by eostic
Wed May 22, 2013 8:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Web-Service Tracking/Logging?
Replies: 3
Views: 1473

At one point years ago we had a user exit for coding your own monitoring things in java based on events within RTI (the former ISD), but it didn't get enough usage, and there are so many other things that tools specializing on this space can address.....from security, to payload alterations, to coun...
by eostic
Tue May 21, 2013 9:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Web-Service Tracking/Logging?
Replies: 3
Views: 1473

Take a look at tools like Actional and others like it. They used to have a great tool for front-ending web services, monitoring their traffic, etc. etc. Also great in this area are the various xml "appliances". Data Power is one that can do some very serious things with web services, inclu...
by eostic
Tue May 21, 2013 9:29 am
Forum: General
Topic: Second installation: same metadata repository?
Replies: 4
Views: 1095

Two Information Server instances cannot share a single xmeta. ...if the desire is for two entirely independent Information Server installations, that can be done, but each will have their own DS engines, their own WAS', their own xmeta repositories, etc.

Ernie
by eostic
Tue May 21, 2013 5:21 am
Forum: General
Topic: Second installation: same metadata repository?
Replies: 4
Views: 1095

That may be two servers, but it's still "one domain" ...meaning...it sounds like one "Information Server" configuration. None of it will work unless both servers are up and running, so I am a bit unsure about what they are saying in the middle of your post.... I assume from the d...
by eostic
Thu May 16, 2013 12:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: generating only one file from xml stage
Replies: 2
Views: 1759

Take a close look at the "mappings" tab of your XML Composer step. If you want one single document, aim to have "Top" map to the "document collection".....chances are there is something else mapped to Top...play with that and its behavior and you are likely to find the ...
by eostic
Thu May 16, 2013 12:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Stage
Replies: 6
Views: 3194

I think we're all getting confused, but I believe we're all talking about the same thing.... IF you have data in DB2 that is just "regular rows and columns" (not currently in XML format), and you want to read from DB2, generate XML and then put that XML into a queue, you can easily do this...
by eostic
Thu May 16, 2013 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Stage
Replies: 6
Views: 3194

You are correct in your first assumption....the xml stage provides the ability to build a potentially complex xml document and then send it downstream.....for loading to a file, a database, or in your case, to MQ.

Ernie
by eostic
Wed May 15, 2013 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Data formatted
Replies: 2
Views: 1494

Your output is probably getting truncated. Use only one big column on the output link. Something like "myResponse" with longvarchar and length of 999999. Go to the message tab of the output tab and pick your one single column from the user-defined-message pull down. Send the output to a se...
by eostic
Mon May 13, 2013 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error updating XML column in DB2
Replies: 12
Views: 4277

using the LOB support (pass long strings by reference)

I have seen very little call for this feature since its inception, but several years ago the Connectors provided DataStage with the ability to handle extremely long strings in a "pass by reference" fashion. I haven't tried it in years, but take a look at this DeveloperWorks article that ta...