Search found 53125 matches

by ray.wurlod
Tue Feb 01, 2011 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hash file concepts
Replies: 3
Views: 1767

Welcome is aboard.

U is the name of one of our posters (it's a Burmese name), so please use the correct spelling of "you".

Is this an interview question?
by ray.wurlod
Tue Feb 01, 2011 4:07 pm
Forum: IBM QualityStage
Topic: Which columns for standardizing names using USNAME rule set?
Replies: 13
Views: 6795

Use as much information as you have. This might also include title, generational (e.g. JR), suffix, ..., whatever.
by ray.wurlod
Tue Feb 01, 2011 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to capture warnings from project level
Replies: 1
Views: 1150

Posting the same question in multiple places will not earn you any extra or different answers. Worse, it annoys those of us who try to answer every question that we can.
by ray.wurlod
Tue Feb 01, 2011 2:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capture warning from project level
Replies: 2
Views: 1711

Script it with dsjob. Iterate through the list of jobs produced by dsjob -ljobs then, for each job name, extract the warnings and errors from the log (again using dsjob), redirecting to a file of your choice.
by ray.wurlod
Tue Feb 01, 2011 1:44 am
Forum: General
Topic: Sequencer Activity Trigger Condition Issue
Replies: 2
Views: 1645

Enclose your ASCII art in Code tags so that the spacing is preserved. You can have whatever triggers you like. It is not mandatory to have an OK trigger. Tip: when you do compare values of job status use the DataStage constants such as DSJS.RUNOK and DSJS.RUNWARN. If "they" ever change the...
by ray.wurlod
Tue Feb 01, 2011 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Abort a DS job based on a condition
Replies: 9
Views: 5034

Maybe it's an interview question.

I'll bet a small amount that, when "they" are presented with the Wrapped stage possibility, that they exclude that too.

You could always have an operator watch the values go by and pull the power plug when they see a bad value.
:wink:
by ray.wurlod
Tue Feb 01, 2011 1:39 am
Forum: General
Topic: Missing Parameters passed
Replies: 4
Views: 1679

Look in the Job Control code for each sequence, in particular the parts where the parameter values are set. If you spot something there, such as "" being the assigned value, check the corresponding job activity in the sequence to verify that parameter value expressions have, indeed, been p...
by ray.wurlod
Mon Jan 31, 2011 8:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in "import" operator: Error in operator arg
Replies: 2
Views: 2451

Not enough information. What data type is NSF? What data type is NSF_?
Does a "$" in this field have any particular purpose, such as null field value? What's in the particular source rows identified in the error message?
by ray.wurlod
Mon Jan 31, 2011 7:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Abort a DS job based on a condition
Replies: 9
Views: 5034

If "they" think that it can be done, demand to know how.
by ray.wurlod
Mon Jan 31, 2011 7:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Abort a DS job based on a condition
Replies: 9
Views: 5034

There is no other way.

<rant>Resist stupid requirements!</rant>
by ray.wurlod
Mon Jan 31, 2011 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xmeta got filled up, Cleaning Xmeta repository
Replies: 4
Views: 5005

Involve your official support provider.

You might try clearing the logs from Director.

But at some point you're clearly going to need to allocate more space.
by ray.wurlod
Mon Jan 31, 2011 3:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Abort a DS job based on a condition
Replies: 9
Views: 5034

Transformer to detect condition and send row to a reject link on which you institute a row limit of 1.
by ray.wurlod
Mon Jan 31, 2011 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Loading Data into the Table.
Replies: 1
Views: 1449

DB2 is rejecting your connection requests because it says it is too busy at that time. Have a word with your DBA about scheduling.
by ray.wurlod
Mon Jan 31, 2011 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD Connector Version 12
Replies: 1
Views: 1435

The stage is at version 8.1, which is the latest.
by ray.wurlod
Mon Jan 31, 2011 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File Name Issue....
Replies: 6
Views: 2873

Have the file land in a particular folder. In a sequence use a DIR /B command to get the file name and feed it to your job. Move the file to a different folder when done.