Search found 53125 matches

by ray.wurlod
Sun Mar 02, 2008 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable Create Copy or Save As Job
Replies: 11
Views: 7173

Search would be a good idea. There are very few reasons why an operating system file (in this case RT_CONFIG20857) can not be created. In summary they are (a) permissions, (b) disk full, (c) disk quota exceeded or (d) limit on number of subdirectories in a directory exceeded. Do you really have mor...
by ray.wurlod
Sun Mar 02, 2008 11:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NOT GETTING PERFORMANCE STATISTICS
Replies: 16
Views: 5235

It is because DataStage Designer can not communicate with the performance monitor application (a separate Java application) that the row counts are unable to be displayed in Designer. If you set the indicated environment variable to the location of PXEngine, then DataStage Designer will be able to f...
by ray.wurlod
Sun Mar 02, 2008 9:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: handling special characters
Replies: 0
Views: 1084

Do you have NLS enabled? Can you create a job that generates the code point for those particular characters, using the Seq() function? Put strings containing those characters in a file, and view the result of the function. Curiously, I note that neither Char() nor Seq() is mentioned in the Appendix ...
by ray.wurlod
Sun Mar 02, 2008 4:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: QS Survival or ...?
Replies: 3
Views: 1135

Have you done any QualityStage training. It requires the result of a Match in order to do Survivorship.

You could profitably have posted this question in the QualityStage forum.
by ray.wurlod
Sun Mar 02, 2008 4:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between blank and null
Replies: 2
Views: 2591

And "" is not a possible value for a Char(3) column. A Char(3) column must have precisely three characters, or be null. (If one or more of the characters is 0x00 then the field can appear to be shorter, but this is merely an artifact of how C handles strings.)
by ray.wurlod
Sat Mar 01, 2008 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join tables on multiple columns and pull matching data.
Replies: 3
Views: 1216

What do you mean by "(hex)" in the original question?
by ray.wurlod
Sat Mar 01, 2008 2:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Constant feed to DS Job
Replies: 6
Views: 1427

What makes you think that you'll get a performance boost? Indeed, how do you define "performance" in such a vague context. You certainly get a functionality boost - quite a few new toys and a common Repository that can be shared (to some extent) with other tools. Therefore arguably there is a potent...
by ray.wurlod
Sat Mar 01, 2008 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dev Environment
Replies: 4
Views: 1088

Prayer is apparently beneficial.
by ray.wurlod
Fri Feb 29, 2008 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: runLocally did not return AP error in PX job
Replies: 9
Views: 4817

They are somewimes written to the scratch disk defined in your configuration file for the node in question.
by ray.wurlod
Fri Feb 29, 2008 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Upsert without a Unique Constraint on DB2 Table
Replies: 1
Views: 610

Only by checking for existence of the value within your DataStage job.
by ray.wurlod
Fri Feb 29, 2008 3:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pls explain using #PARAM1# and #$PARAM1#
Replies: 2
Views: 781

The one without the "$" character is a "regular" job parameter. The one with the "$" character is a job parameter that is a reference to the environment variable called PARAM1.
by ray.wurlod
Fri Feb 29, 2008 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Constant feed to DS Job
Replies: 6
Views: 1427

You might consider using server jobs, or parallel jobs with a low degree of parallelism, to keep the startup time as short as possible. Another possibility is an "always running" job using WISD to publish your DataStage job as a web service that the Perl application could invoke. In this case startu...
by ray.wurlod
Fri Feb 29, 2008 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while Loading a table using ORACLE
Replies: 8
Views: 3126

The second person personal pronoun in English is spelled "you", not "u".
by ray.wurlod
Fri Feb 29, 2008 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Size errror in Transformer
Replies: 13
Views: 3971

The error is actually thrown by APT_CombinedOperatorController - you have no idea which stage is to blame. That's why we rarely attempt to diagnose errors from this operator. It may even be that the heap problems come from an inserted tsort operator.
by ray.wurlod
Fri Feb 29, 2008 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warnings in sort and remove duplicate stages.
Replies: 1
Views: 1025

Answers to all of these can be found using Search