Search found 53125 matches

by ray.wurlod
Tue Aug 10, 2010 4:43 pm
Forum: IBM QualityStage
Topic: Match Frequency
Replies: 3
Views: 2226

The match frequencies are used to determine the reliability of the fields used as matching fields. The more frequently a value occurs in its domain the less information content it contributes to the match, and vice versa. This information is used when calculating the agreement/disagreement weights i...
by ray.wurlod
Tue Aug 10, 2010 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to view the Log file.
Replies: 20
Views: 4962

Please run the following command from the Administrator client:

Code: Select all

UVFIXFILE RT_LOG43
Report your findings.
by ray.wurlod
Tue Aug 10, 2010 5:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: About The Latest Tools Availability
Replies: 5
Views: 1901

Subscribe To An Agency Such As Gartner Group, Who Specialize In Providing This Kind Of Information.
by ray.wurlod
Tue Aug 10, 2010 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Jobs Not Running
Replies: 28
Views: 16223

That suggests that you have set "reset if required, then run" in the job activities in your sequence. Does the log later report "job has been reset"?
by ray.wurlod
Tue Aug 10, 2010 2:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: about forums
Replies: 2
Views: 952

Everything that could be construed as "latest updates" - whether documentation, release notes, software, etc., is available from an IBM website. For some of them you will need an IBM registered ID, but that's free of monetary cost. So why not look there?
by ray.wurlod
Tue Aug 10, 2010 2:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Jobs Not Running
Replies: 28
Views: 16223

Re: Datastage Jobs Not Running

paranoid wrote:... the jobs failed for the same reason and we could finish them after re-running those scripts manually....
What was the reason?
Are ANY events logged either in DataStage logs or in cron (or script) logs?
by ray.wurlod
Tue Aug 10, 2010 12:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: particular character search
Replies: 1
Views: 745

Welcome aboard. The Index() function can test for the existence of a substring in a string. You can also remove all the functions from your string using Convert() function then compare the length of the result with the length of the original string - if they're different then one of the characters w...
by ray.wurlod
Tue Aug 10, 2010 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Reject
Replies: 3
Views: 2261

A reject link does not mean the same thing in a parallel Transformer stage as it does in a server Transformer stage. In the parallel Transformer stage it is the Otherwise/Log link that handles any row that has not been handled by any earlier output link in the output link execution order. The reject...
by ray.wurlod
Tue Aug 10, 2010 12:31 am
Forum: IBM QualityStage
Topic: Lower Case Output from quality stage standardization
Replies: 7
Views: 3704

Please mark this thread as Resolved using the green button at top.
by ray.wurlod
Mon Aug 09, 2010 8:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run shell scripts in sequence jobs
Replies: 6
Views: 1491

Re: How to run shell scripts in sequence jobs

how should i use them in the sequence jobs Invoke from Execute Command activity. what conditions ineed to keep to make sure it runs successfully....... That's entirely within the purview of the author of the shell script. The job sequence will detect the exit status of the shell script (accessible ...
by ray.wurlod
Mon Aug 09, 2010 5:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Validation
Replies: 15
Views: 4321

Code: Select all

If Len(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789", "", InLink.TheString)) = 0 Then Left(InLink.TheString, 20) Else ""
by ray.wurlod
Mon Aug 09, 2010 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to set not null column to null
Replies: 16
Views: 8999

It is not null column and i want it to be null when there is no data This won't work anywhere. If it's not null you simply can not set it to be truly null. That would break a rule, and the rule is enforced. Choose an "in-band null" - a value (perhaps blank) that is valid for the data type...
by ray.wurlod
Mon Aug 09, 2010 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variables...
Replies: 2
Views: 1179

There are no assignments in any expression. Your stage variable derivation should read only

Code: Select all

If DSLink12.KeyChange=1 then 1 else StageVar+1
by ray.wurlod
Mon Aug 09, 2010 3:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage is down
Replies: 8
Views: 3182

You have not given us enough information to be able to formulate a cogent reply. Under what circumstances does this text appear, and what (precisely) are you doing at that time?