Search found 53125 matches

by ray.wurlod
Tue Oct 27, 2015 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transposing input row into multiple rows
Replies: 7
Views: 1975

The "used to be" part is not an urban legend. It was true. It was fixed.
by ray.wurlod
Tue Oct 27, 2015 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi node configuration in standalone installation?
Replies: 7
Views: 2979

I disagree with Paul, although he is correct. But you can also configure your installation such that all your projects are on machine 1, and machine 2 is used only for processing. You do this by mentioning both machines in the parallel execution configuration file, even though the engine is installe...
by ray.wurlod
Tue Oct 27, 2015 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi node configuration in standalone installation?
Replies: 7
Views: 2979

The PXEngine directory has to be visible to both machines. It can be cross-mounted, or it can be "distributed" to the second machine.
by ray.wurlod
Tue Oct 27, 2015 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transposing input row into multiple rows
Replies: 7
Views: 1975

Re: Transposing input row into multiple rows

mouthou wrote:A similar option I was looking for without a Transformer!
Why?
by ray.wurlod
Sat Oct 24, 2015 10:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Why not hash partitioning for lookup stage
Replies: 7
Views: 6544

You can use any partitioning anywhere. But only certain partitioning will achieve correct results when key adjacency is required. It is actually best practice to partition both inputs of the Lookup stage identically. (Auto) uses Entire because there's no requirement that the column names be the same...
by ray.wurlod
Sat Oct 24, 2015 10:52 pm
Forum: General
Topic: issuse with ds director
Replies: 4
Views: 1049

And if you want to know about re-indexing the local repository, search here for DS.REINDEX ALL command.
by ray.wurlod
Sat Oct 24, 2015 10:51 pm
Forum: General
Topic: Job activity not moving to next activity
Replies: 2
Views: 1138

Your ACTUAL problem, then, is a job that is not finishing? You need to diagnose the reason for that first.
by ray.wurlod
Sat Oct 24, 2015 10:50 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Description of format results from Column Analysis
Replies: 9
Views: 6887

Provided everything you have told us is the complete picture, then a patch will be needed. That involves notification through your official support provider.
by ray.wurlod
Fri Oct 23, 2015 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transposing input row into multiple rows
Replies: 7
Views: 1975

I'd be quite happy to specify 25 output links.
by ray.wurlod
Fri Oct 23, 2015 3:24 pm
Forum: General
Topic: Display record count in Job Log
Replies: 3
Views: 1035

Read again what Craig said and, while you're waiting for support, learn about the printf family of functions.
by ray.wurlod
Thu Oct 22, 2015 6:21 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Description of format results from Column Analysis
Replies: 9
Views: 6887

Format of NA usually means NULL. It may also mean, rarely, that the data value is not appropriate for the defined data type.

Check that you drilled down on the correct format.
by ray.wurlod
Wed Oct 21, 2015 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variable - Order of execution
Replies: 8
Views: 3346

Top to bottom.

Stage variables not yet executed retain their value from the previous row (or from initialization if processing row number 1).

Just curious: why are you asking?
by ray.wurlod
Wed Oct 21, 2015 3:13 pm
Forum: General
Topic: Urgent.... Routine call java fail
Replies: 2
Views: 1420

So I guess it's not urgent any more? DSXchange is not the place for "urgent". Members post as and when they can, and are under no obligation to do so. If you need urgent assistance, sign up with your official support provider for premium service, and learn just how much "urgent" ...
by ray.wurlod
Tue Oct 20, 2015 7:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOW TO INVOKE THE DsSetUserStatus routine?
Replies: 4
Views: 5296

Use a BASIC Transformer stage, and call an interlude transform function that invokes DSSetUserStatus.
by ray.wurlod
Mon Oct 19, 2015 10:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle 12c compatibility with DS 9.1 and DSODB database
Replies: 2
Views: 2191

Except that you don't get any new functionality, the 11g clients are compatible with a 12c database server.