Search found 3835 matches

by eostic
Tue Sep 15, 2009 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in reading response from MQ
Replies: 11
Views: 5104

Further to that answer, the Job ought to look like:

MQConnector --- XMLOutput --(extract your return code and other such things) ---- other parts of the job, branching as necessary for FATAL, etc..

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

As JRodriguez, noted, read the payload (xml in your case) as char and then process downstream..... in this case, w/XMLInput, or in other cases, if it were (for example) csv, with Column Import. In the case of XML, I can't see why you would EVER want "Treat EOL as row terminator" = YES. Thi...
by eostic
Mon Sep 14, 2009 9:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in reading response from MQ
Replies: 11
Views: 5104

Hi pradumar... What is your ultimate goal? Is there a reason you can't use EOL terminator = Yes? It's not clear to me what error scenario you are trying to detect. There are many many properties in the new MQ Connector....there are many unique combinations that probably aren't used often together......
by eostic
Mon Sep 14, 2009 9:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Validation Against XSD
Replies: 15
Views: 11868

You fully qualified it above, and I missed it. Sorry...pointing specifically to the subdirectory and exact name of your xsd is what I was referring to. Call support..there were some patches to validation, although they were a long time ago...something still may be wrong, or maybe the patches still n...
by eostic
Mon Sep 14, 2009 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in reading XML
Replies: 1
Views: 799

scroll to the right in the column grid of your output link.... take a look at the formal XPATH strings that are there....in general, if you have mytag/text() at the end of each, you will get only the "value" of the tag ("mytag" in this example)...if you just end with /mytag you w...
by eostic
Mon Sep 14, 2009 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Validation Against XSD
Replies: 15
Views: 11868

hmm. Try fully qualifying the xsd within the noNameSpaceSchemaLocation attribute and see what happens.

Ernie
by eostic
Sat Sep 12, 2009 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Duplicates issue in XML OUTPUT STAGE to generate xml
Replies: 4
Views: 1242

...there are lots of great string functions in a BASIC Transformer, or...just do the whole Job in a Server Job instead and use a regular transformer....I'd have to see your actual resulting string, but I'll be that a couple of nested ereplace()'s would work just fine.....

Ernie
by eostic
Fri Sep 11, 2009 9:29 am
Forum: DSXchange Testimonials
Topic: not happy with this site..
Replies: 9
Views: 17315

Your criticism is mis-placed...if you have an issue with the $100 you spent, and the behavior of the restrictions, and are frustrated with that, so be it --- but to challenge that the site "has given me no use since I joined" is not justified. There's enormous value in this site just from ...
by eostic
Thu Sep 10, 2009 3:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Duplicates issue in XML OUTPUT STAGE to generate xml
Replies: 4
Views: 1242

A strange issue indeed. I've found that the easiest way to alleviate this is to ensure that the sub-elements cannot be the same. Add another element as an immediate sub-node and then edit it out afterwards in a downsteam transformer, by sending your output to a single column on the output link...a v...
by eostic
Thu Sep 10, 2009 6:18 am
Forum: General
Topic: ImportExportManager
Replies: 3
Views: 912

Hi... I use it all the time....it has its moments, but works successfully to bring in Cognos metadata. I do believe there were numerous patches to it, so you might want to contact your support provider if you have a version that is earlier than probably May of this year... I haven't experienced the ...
by eostic
Wed Sep 09, 2009 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can DataStage write to JMS Queue
Replies: 5
Views: 6467

JavaPack is the general term for the JavaTransformer and JavaClient Stages. This "is" the way to connect to JMS. Look in the real-time category of stages. They are installed automatically in 8.1. Then spend some time with http://dsrealtime.wordpress.com/2008/03/14/incorporating-java-classe...
by eostic
Wed Sep 09, 2009 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple repeating Elements
Replies: 18
Views: 6693

Hi.... Sorry that it has been difficult fully appreciating what you are trying to accomplish.... ....on this latest issue though, it would appear that your previously generated XML string is getting "escaped". You should be able to avoid that by using Data Element "XML" on the co...
by eostic
Tue Sep 08, 2009 2:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transformer Function Problem
Replies: 4
Views: 1459

It sounds to me like the question is whether you can sort by the desc inside the GUI.. (ie...when you are "editing" a particular instance of the Transformer Stage)? If that's the actual question, I haven't ever found a way. Something I've wished for all the stages, especially ever since ce...
by eostic
Tue Sep 08, 2009 5:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i replace an XML element (Web Services Transformer)
Replies: 2
Views: 993

...just one? ...if it's not a HUGE xml document, I would just pass it into a Transformer and do it there... especially a BASIC Transformer. The BASIC Transformer is chock full of text functions that make pulling out a single string between delimieters (in this case, tags) fairly easy. You could also...
by eostic
Fri Sep 04, 2009 1:19 pm
Forum:
Topic: Any Bridges?
Replies: 2
Views: 1244

Look on your install media. There is an import export manager subdirectory there...install it separately from there into your Windows environment.

Ernie