Search found 53125 matches

by ray.wurlod
Tue Oct 18, 2011 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to properly use pivot/pivot enterprise
Replies: 6
Views: 1472

Derive MEASURE as B15002A_1_EST,B15002A_2_EST,B15002A_3_EST
by ray.wurlod
Tue Oct 18, 2011 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Hello" from Parallel Routine
Replies: 1
Views: 1119

Use any text editor to create the source code.
Compile it using the compiler referred to in APT_COMPILER with options as per APT_COMPILE_OPTIONS.
Link it ising the linker referred to in APT_LINKER with options as per APT_LINKER_OPTIONS.
by ray.wurlod
Tue Oct 18, 2011 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in Director
Replies: 3
Views: 2095

Are you sorting on all of the join keys in ascending order?
by ray.wurlod
Tue Oct 18, 2011 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: join two keys with lookup stage
Replies: 7
Views: 2089

Lookup stages don't have constraints.
by ray.wurlod
Tue Oct 18, 2011 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to retrieve or insert data into DB2
Replies: 13
Views: 4420

U (who is one of our posters) was not involved.

The second person personal pronoun in English is spelled "you".

Please strive for a professional standard of written English on DSXchange, not least because it helps those whose first language is not English.
by ray.wurlod
Tue Oct 18, 2011 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: header and trailer validation
Replies: 10
Views: 4286

Perhaps you need to specify more exactly what you mean by "validate".
by ray.wurlod
Tue Oct 18, 2011 3:41 pm
Forum: General
Topic: File creation date = Current Date then start DS Sequence
Replies: 3
Views: 1613

Otherwise you can use the STATUS statement in a Routine activity to return the modification date (and lots of other information about the file).
by ray.wurlod
Tue Oct 18, 2011 3:39 pm
Forum: General
Topic: Having trouble in installing Infosphere Information Server
Replies: 1
Views: 721

And have you read the Release Notes? What did they tell you about the graphics environment?
by ray.wurlod
Tue Oct 18, 2011 3:38 pm
Forum: General
Topic: Subroutine Help
Replies: 9
Views: 2435

Stop pushing! It's very offensive. You only waited three hours. I was sound asleep for all of them.
:x

Research BCI functions.
by ray.wurlod
Tue Oct 18, 2011 3:35 pm
Forum: General
Topic: CPU requirements DataStage 8.5
Replies: 6
Views: 4594

That's because CPU really is an "it depends" factor. If no jobs were running your clients would have no trouble connecting. Why would you expect IBM to be able to predict the load that you propose to put on the servers? It's just not possible. The equation is simply supply and demand, as w...
by ray.wurlod
Tue Oct 18, 2011 3:25 pm
Forum: IBM QualityStage
Topic: Migrate from 7.0 to version 8.5
Replies: 1
Views: 1635

This is the "concierge service" from IBM. I have not used it; I discussed it with them but they felt I was experienced enough to venture alone into the vastly different world of version 8.5. It turned out they were right. Basically it's IBM coming in with a comprehensive checklist of thing...
by ray.wurlod
Tue Oct 18, 2011 12:14 am
Forum: General
Topic: dsexport without dependent items
Replies: 9
Views: 6417

Read the error carefully, then specify a user and password that does have the requisite role.
by ray.wurlod
Tue Oct 18, 2011 12:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delimiters in file
Replies: 8
Views: 1955

Ur was a city in ancient Babylonia. The second person personal pronoun in English is spelled "your", not "ur". Please strive to maintain a professional standard of written English on DSXchange, not least because it helps those whose first language is not English. Also strive to ...
by ray.wurlod
Tue Oct 18, 2011 12:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delimiters in file
Replies: 8
Views: 1955

Specify | as the field delimiter.

You have four fields. If you only really have three, specify | as the final delimiter too.