Search found 53125 matches

by ray.wurlod
Mon Nov 22, 2010 3:01 pm
Forum: General
Topic: Looping Activity in DataStage
Replies: 9
Views: 7152

---> StartLoop <--------------------- EndLoop | ^ | | V | DoStuff --------> Test -----------+ | >0 | = 0 V DoNothing
by ray.wurlod
Mon Nov 22, 2010 2:56 pm
Forum: General
Topic: Putting all messages in one log file
Replies: 4
Views: 1192

dsjob -jobinfo output includes a field called "controller". This is typically the parent sequence from which the job was invoked. Therefore, when your Ctrl-M script uses dsjob to retrieve information about status, also select the controller from that result.
by ray.wurlod
Mon Nov 22, 2010 2:53 pm
Forum: General
Topic: How to mail rejected records..
Replies: 18
Views: 5600

Your BASIC Transformer stage does not have a reference input. However, your Lookup stage does. Investigate that.
by ray.wurlod
Mon Nov 22, 2010 2:50 pm
Forum: IBM QualityStage
Topic: Reference Match - all records going to all match passes
Replies: 4
Views: 1841

I don't think you can do that in a multi-pass single match. I suspect you're going to need more than one match stage, maybe even in separate jobs. And then, of course, you will have the dilemma of combining the sets of records - you may need to introduce an artificial key to the source stream.
by ray.wurlod
Mon Nov 22, 2010 2:48 pm
Forum: IBM QualityStage
Topic: Ouptput question QS 7.5 vs QS 7.0
Replies: 4
Views: 1924

Are you running these in the parallel engine or the server engine? If parallel, are the configuration files the same (contain the same number of nodes)?
by ray.wurlod
Mon Nov 22, 2010 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOW TO FIND CHINEES CHARECTER
Replies: 1
Views: 1975

First you need to find out how your Chinese characters are encoded (for example GB2312 or BIG5), then how these are mapped to Unicode. Consult Unicode code tables to determine which code points represent Chinese characters (don't forget the CJK characters, which are shared between Chinese, Japanese ...
by ray.wurlod
Mon Nov 22, 2010 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_DUMP_SCORE
Replies: 1
Views: 1465

Re: APT_DUMP_SCORE

What additional data we will get into our logs, if we add this environmental variable to our job? One additional entry, containing the score. How this variable help us to performance tuning? It shows you the actual job that gets executed, which may be quite different from what is designed. With suf...
by ray.wurlod
Mon Nov 22, 2010 5:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Stage variable increment not working
Replies: 12
Views: 9861

It IS correct. The even numbers are on the other node.
by ray.wurlod
Mon Nov 22, 2010 5:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handdle chars '<' and '>' in XML Output Stage
Replies: 3
Views: 1818

That's what I meant with "mark as XML". Too used to it, I guess.
by ray.wurlod
Mon Nov 22, 2010 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to add excel files
Replies: 5
Views: 1494

Converting is not the same thing as renaming.
by ray.wurlod
Mon Nov 22, 2010 5:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of all DS jobs
Replies: 3
Views: 1492

Export the entire project.
by ray.wurlod
Mon Nov 22, 2010 5:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS 7.5.2 Migration
Replies: 2
Views: 1167

Every operating system version of DataStage is different. You install on AIX, then export from Solaris and import on AIX. There's no alternative.

Make sure you pick up other things like any hashed files, scripts and the like that have to be migrated.
by ray.wurlod
Mon Nov 22, 2010 5:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Converting from rows to Columns
Replies: 3
Views: 1959

Everything additional you do must necessarily degrade performance. Do only that which you must do.
by ray.wurlod
Mon Nov 22, 2010 5:18 am
Forum: General
Topic: How to mail rejected records..
Replies: 18
Views: 5600

Before-job subroutines and after-job subroutines in parallel jobs are server routines.

Routine activities in sequences invoke server routines.
by ray.wurlod
Mon Nov 22, 2010 5:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job in running state but not writing any logs
Replies: 2
Views: 7016

Not until you post in the correct forum so that "some one" can know what version, what edition, what platform this problem is occurring on.