Search found 53125 matches

by ray.wurlod
Thu Jul 03, 2008 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compile Vs Force Compile
Replies: 4
Views: 5971

You should rarely need Force Compile. When you change a job design but make no changes to Transformer stage(s) in that job, when you compile the job the step of generating, compiling and linking C++ code from the Transformer stage is skipped (since nothing changed). Force Compile forces this step to...
by ray.wurlod
Thu Jul 03, 2008 12:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container name
Replies: 15
Views: 4123

Code: Select all

WHERE NAME = '<<Job name>>');
by ray.wurlod
Thu Jul 03, 2008 12:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want multiple operations executed in if condition
Replies: 4
Views: 1601

There are no assignments. For example

Code: Select all

If (condition = 0) Then "A" Else If (condition = 1) Then "B" Else If (condition = 2) Then "C" Else "D"

The parentheses are not necessary; I included them only for clarity.
by ray.wurlod
Thu Jul 03, 2008 12:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with NLS
Replies: 10
Views: 7401

Welcome aboard. Sounds like you need to get some DataStage training.

The dsenv script is on the server, in the DataStage engine directory.
by ray.wurlod
Thu Jul 03, 2008 12:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while compiling the job
Replies: 15
Views: 9399

Can you compile other Transformer stages? Can you compile this one without the routine reference?

This error is sometimes seen if the compiler license is expired or exceeded.
by ray.wurlod
Thu Jul 03, 2008 12:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify
Replies: 10
Views: 3528

So you learn that it DOES do implicit conversion in this case.
by ray.wurlod
Thu Jul 03, 2008 12:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Job design logic
Replies: 1
Views: 768

Two outputs from Transformer stage, one for GL and one for LCL. Bring them together subsequently with an Aggregator stage.
I think you can figure out the column derivations.
Add a "key" column (derived as @INROWNUM) that you can use to re-unite the original rows.
by ray.wurlod
Thu Jul 03, 2008 12:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Server 7.5.1A migration issue to 7.5.3
Replies: 16
Views: 8460

Bring environment variable APT_DISABLE_COMBINATION into your job as a job parameter and, when you run the job, set it to True.
by ray.wurlod
Thu Jul 03, 2008 12:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge
Replies: 8
Views: 1619

Please post the exact and entire error message.
by ray.wurlod
Wed Jul 02, 2008 7:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: not able to find custom built stage in data stage compilatio
Replies: 6
Views: 2605

I believe that you can only compile a Build stage from within the stage properties dialog.
by ray.wurlod
Wed Jul 02, 2008 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Suppress Warning: Fixed Width File
Replies: 2
Views: 1189

Get the line terminator character defined correctly.
Or add FILLER PIC X. to the file definition.
by ray.wurlod
Wed Jul 02, 2008 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Decimal Issue
Replies: 6
Views: 2584

Code: Select all

StringToDecimal(Left(InLink.TheString,2) : "." : Right(InLink.TheString,7))
by ray.wurlod
Wed Jul 02, 2008 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting Date character type to NULL in Row Generator
Replies: 1
Views: 1426

Welcome aboard. The generator operator can generate a proportion of null or invalid values, so you could try setting that to 100% for the column in question. Otherwise interpose a Transformer stage.
by ray.wurlod
Wed Jul 02, 2008 4:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find any one of characters in a string?
Replies: 1
Views: 755

No, but if you convert all of those to "" and check the length of the remainder you have a solution.
Your constraint expression would have the form

Code: Select all

Len(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ","",InLink.TheString)) = 0
by ray.wurlod
Wed Jul 02, 2008 4:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify
Replies: 10
Views: 3528

Delete the Data Set from Data Set Management utility then re-run the job. Do the same results obtain?