Search found 53125 matches

by ray.wurlod
Thu Mar 12, 2009 12:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD TYpe2 Process
Replies: 5
Views: 1303

Add at least one of the required columns. Type 2 SCD doesn't make sense without one or both of them.
by ray.wurlod
Thu Mar 12, 2009 12:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Implementing job dependencies in a sequence job
Replies: 7
Views: 1815

Code: Select all

         B --+
             |
A --+        +--> G --+
    |        |        |      --> I
    +--> F --+    D --+--> H --> J  
    |                 |      --> K
C --+             E --+
+--> represents an "All" Sequencer
by ray.wurlod
Wed Mar 11, 2009 10:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Standardize,0: Error occurred on line 96 of file .\RT_QS8\V0
Replies: 3
Views: 1182

Two questions, one answer. Hmm. Have you provisioned an invalid rule set?

Have you looked into .\RT_QS8\V0 in the project directory on the server? If so, what's there? In particular, what's there around line #96?
by ray.wurlod
Wed Mar 11, 2009 10:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ensuring hashed file is created when the job executes
Replies: 11
Views: 4139

Put your ASCII art inside code tags.

Best practice to ensure that a hashed file exists is to create a separate job to create it. This needs only a transformer stage and a hashed file stage.
by ray.wurlod
Wed Mar 11, 2009 10:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Implementing job dependencies in a sequence job
Replies: 7
Views: 1815

Sequencers.

It's not clear whether G depends on F. Does it?
by ray.wurlod
Wed Mar 11, 2009 8:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hash partition and scratch space
Replies: 7
Views: 2533

Data Sets do NOT use scratch space.

Look elsewhere for your problem.

Data Sets use resource disk directories.
by ray.wurlod
Wed Mar 11, 2009 8:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Byte Order Mark
Replies: 4
Views: 1697

Edited earlier post with respect to job type.
by ray.wurlod
Wed Mar 11, 2009 8:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Byte Order Mark
Replies: 4
Views: 1697

Edited earlier post with respect to job type.
by ray.wurlod
Wed Mar 11, 2009 8:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage installations on Wintel v/s HP-UX?
Replies: 4
Views: 1665

The upper limits on Wintel hardware are reached far more quickly than the upper limits on HP-UX hardware.
by ray.wurlod
Wed Mar 11, 2009 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage installations on Wintel v/s HP-UX?
Replies: 4
Views: 1665

The upper limits on Wintel hardware are reached far more quickly than the upper limits on HP-UX hardware.
by ray.wurlod
Wed Mar 11, 2009 8:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Standardize,0: Error occurred on line 96 of file .\RT_QS8\V0
Replies: 3
Views: 1182

Moderator: please move to QualityStage forum.

Have you tested your rule set using the Rule Set Analyzer (in the Tools menu)?

Have you provisioned the rule set to the server?
by ray.wurlod
Wed Mar 11, 2009 8:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Status code 96 DSJS_CRASHED
Replies: 16
Views: 6085

No, that doesn't define it, that uses it. However line 2134 assigns a value to it, that being the result of testing whether ErrorMsg is empty.

Code: Select all

02134 05014 : 06E eq             ErrorMsg ""  => $R246 
by ray.wurlod
Wed Mar 11, 2009 2:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs Status not compiled
Replies: 3
Views: 1470

Welcome aboard.

In Director disable display of Categories (in View menu) then sort by status. Adjust the size of the display to show only the Not Compiled jobs and use the Print option (from Project menu) to print the current page.

Reset display of Categories once you're done.
by ray.wurlod
Wed Mar 11, 2009 2:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Byte Order Mark
Replies: 4
Views: 1697

There is an optional property (Options folder?) in the parallel job Sequential File stage for handling the Byte Order Mark. At least it's there if NLS is enabled. I haven't checked where NLS is not enabled. (You have marked your job type as "server" even though you've posted in the Paralle...
by ray.wurlod
Wed Mar 11, 2009 2:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping Function
Replies: 14
Views: 8499

Welcome aboard. Please post the ACTUAL error message.