Search found 53125 matches

by ray.wurlod
Tue Jun 10, 2014 9:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchamdin Utility
Replies: 6
Views: 2506

Check the contents of the configuration file specified at the time the command was run (by $APT_CONFIG_FILE).

Make sure that the node name mentioned in the error message appears in the active configuration file.
by ray.wurlod
Tue Jun 10, 2014 7:52 pm
Forum: IBM QualityStage
Topic: Strange REPEAT behaviour
Replies: 3
Views: 3166

Stuart beat me to it. You need to clear the temp variable.
by ray.wurlod
Tue Jun 10, 2014 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check for the multiple occurance of a string & remove
Replies: 2
Views: 1283

Detecting "more than one" is straightforward; simply use 2 as the third argument of an Index() function. However that would require a priori knowledge of which state code it was. There's probably an easy solution using looping in a Transformer stage but, again, a priori knowledge of the st...
by ray.wurlod
Tue Jun 10, 2014 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Limit to Multiple instance of sequences and D's parallel job
Replies: 5
Views: 2173

Or, since you're on version 9.1, you can configure the workload management queues so that there is a finite upper limit on the number of jobs, the amount of CPU or memory consumed, etc., so that "surplus" jobs don't abort but, instead, wait until resources become available.
by ray.wurlod
Tue Jun 10, 2014 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Connector
Replies: 2
Views: 959

A better answer for (3) is that MQ is best used when either of the following scenarios applies:
  • DataStage is reading from a queue to which another application is writing data

    DataStage is writing to a queue from which another application is reading the data
by ray.wurlod
Tue Jun 10, 2014 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy stage not optimized out of the job
Replies: 4
Views: 1180

Can you show us the copy operator in the score?
by ray.wurlod
Tue Jun 10, 2014 4:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge stage clarification
Replies: 5
Views: 1644

Your understanding is not correct. In this context "unmatched" means across all Update links.

You use reject links for each Update link to capture stream rows for which no match was found.
by ray.wurlod
Tue Jun 10, 2014 4:26 pm
Forum: General
Topic: Not able to Source dsenv
Replies: 2
Views: 2573

It is quite often the case that non-root users are not permitted to raise certain ulimit values. If you wish you can ignore this warning, or direct file unit 2 to /dev/null if you don't want to see it. Of course then you'll miss all error/warning messages from dsenv.
by ray.wurlod
Mon Jun 09, 2014 10:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bulk orchestrate import of table definitions
Replies: 17
Views: 6105

rameshrr3 wrote:Another reason to use Connector table defs is that they are automagically defined as shared table definitions...
Provided that such has been enabled as a General property for the project.
by ray.wurlod
Mon Jun 09, 2014 5:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchamdin Utility
Replies: 6
Views: 2506

So, what is your actual question? Please note that, on UNIX, the command name is entirely in lower case ( orchadmin ). Its executable is to be found in the bin directory of the PX engine, and it requires that a couple of environment variables be set, including APT_ORCHHOME and APT_CONFIG_FILE, befor...
by ray.wurlod
Mon Jun 09, 2014 5:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace a string with another string
Replies: 12
Views: 5888

pxEreplace() is a parallel function created for and improved on this site. A Search should find it for you.
by ray.wurlod
Mon Jun 09, 2014 5:34 pm
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

This task might more easily be performed using a two-file match in QualityStage, making use of array comparisons.
by ray.wurlod
Mon Jun 09, 2014 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CSV file with embedded quotes and commas
Replies: 4
Views: 2255

Maybe they don't want to remove the characters which are, after all, part of the data.
by ray.wurlod
Mon Jun 09, 2014 5:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output issue
Replies: 3
Views: 1706

Re: XML Output issue

sandeepsreedhar wrote: I have to create an xml of the below format.
Why?

Have "they" given you specifics of the namespace(s) that you have to use?
by ray.wurlod
Mon Jun 09, 2014 5:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe program from datastage
Replies: 4
Views: 2476

Are they truly in UniVerse, or they in DataStage?

Either way there is no difference between versions in how they would be invoked.