DSXchange

Always install the compiler first.

If volumes are not large consider using a BASIC Transformer stage with either a Fold() or a Fmt() function.

HOW did you "try to convert"?

Check first in uvodbc.config then in .odbc.ini. You are looking for an illegal configuration option. If you don't find it there you might also look at uci.config in the $DSHOME directory.

Post your job design and be specific about which sequential file is not being created.

The Transformer stage does not use column headings at all, so your diagnosis is incorrect. It is the Sequential File stage with an input link that disallows column headings containing reserved characters. Ken's suggested solution will work; for example use an echo command in a before-stage subroutin...

Doesn't Search work on your computer?

There's only one "do" - analyse the logic and rewrite as a parallel job, taking advantage of the parallel execution architecture (getting sorting and partitioning right, for example).

The major "don't" is don't believe that server jobs can be converted to parallel jobs.

The obvious answer is to take a class. In the meantime, see how the rule sets work without overrides - after all a lot of work has gone into them. Overrides are really meant for exceptional cases, for example when you know that a particular two word string in the name rule set is an organization nam...

But just a tad unreasonable for someone with a post count of 1 (at the time).

You're welcome.

Welcome aboard. I can only guess that ASCL_MS1252 is a reference to Ascential's implementation of Microsoft code page 1252 (US English). Is there any more information in the job log? What are your DataStage NLS settings? Can you please post the EXACT error message (copy/paste), so that we can learn ...

Do you mean that your jobs are not writing any "end of data" message?

I don't know of any way to do it with the API (that is, dsjob or one you wrote yourself). It would, of course, be possible using DataStage/SQL; for example $DSHOME/bin/dssh "SELECT columns FROM RT_LOGnnn WHERE ..." > file I too don't have DataStage readily available at the moment, hence th...

The query in the first post needed two UNION ALL operators in the inner query. UNION alone removes duplicates.