Search found 42189 matches

by chulett
Mon Jun 09, 2014 5:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace a string with another string
Replies: 12
Views: 5888

As noted, there's a link to it in the post this was split from. However, I seem to remember chatter there about memory leaks and other issues with it when Phil played with it last. [shrug]
by chulett
Mon Jun 09, 2014 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchamdin Utility
Replies: 6
Views: 2506

Let's start by getting you in the proper forum... and here we are. I also moved your "additional information" text down into the body of your post so it doesn't seem so... empty.
by chulett
Mon Jun 09, 2014 1:47 pm
Forum: General
Topic: Datastage (Infosphere Information Server) Sizing
Replies: 9
Views: 1640

You might find Eric's reply in this thread of interest.
by chulett
Mon Jun 09, 2014 1:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace a string with another string
Replies: 12
Views: 5888

A BASIC Transformer stage, sure. That's another option.
by chulett
Mon Jun 09, 2014 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage
Replies: 7
Views: 2373

Actually, you missed the part about the image tags and used the normal url tags, which means someone has to click through to your image. I replaced them with the tags I mentioned so you can see the difference. Unfortunately, it doesn't shed any additional light on the subject. How do you know the fi...
by chulett
Mon Jun 09, 2014 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe program from datastage
Replies: 4
Views: 2476

I am not aware of any reason why that would not continue to work as it currently does.
by chulett
Mon Jun 09, 2014 11:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage
Replies: 7
Views: 2373

If they were fine it would be working. :wink: Screenshots on any board like this are handled via the "image" tags. Meaning, you upload your shots to any of the free file hosting services out there (I typically use http://imgur.com/) and then bring them into the post using the [img] tags. T...
by chulett
Mon Jun 09, 2014 10:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage
Replies: 7
Views: 2373

The primary document entity could not be opened

It could not find and open your XML file. Double-check both the filename's value you are passing into the stage and that the running user has the required permissions to read it.
by chulett
Mon Jun 09, 2014 10:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage
Replies: 7
Views: 2373

Based on your error message, I both moved your post to this forum and changed the Job Type from Server to Parallel.
by chulett
Mon Jun 09, 2014 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace a string with another string
Replies: 12
Views: 5888

Others might but I no longer do.
by chulett
Mon Jun 09, 2014 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find whether a substring is present in a field
Replies: 7
Views: 3026

No, there's no reason to hard-code anything in spite of what you saw in those examples.
by chulett
Mon Jun 09, 2014 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace a string with another string
Replies: 12
Views: 5888

You... could, I imagine. Seems like it would be fairly painful, though. I would think the PXEReplace function linked to in the other post would be a better option.
by chulett
Mon Jun 09, 2014 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find whether a substring is present in a field
Replies: 7
Views: 3026

The high level answer is the Index() function, just don't worry about the 'where' of the substring just the fact that it was found (non-zero/true return) or not found (zero/false return). There's also a little game you'd have to play to avoid sub-string matches, I'll see if I can find a post that di...
by chulett
Mon Jun 09, 2014 6:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace a string with another string
Replies: 12
Views: 5888

Split off from this conversation on the same topic. And the answer is still no until you get up into the 9.x release, from what I recall.