DSXchange

Check that your metadata, particularly for Format, are correct. {0d} is carriage return character, which suggests DOS-style line terminator.

The range map is only used when using range partitioning.

If you attempt to use range partitioning you must specify the pathname of the range map (which can be a relative pathname). If you specify a name that cannot be found by the executing user, this message will obtain.

As far as my extensive researches have been able to determine, the server Aggregator stage differs from the parallel Aggregator stage in one particularly fundamental way (and I think we're into the premium content by now) - the server Aggregator stage is used in server jobs and the parallel Aggregat...

Tyro, even.

Of course: there's always the alternative of creating your own (parallel) routine.

You get the migration team to add the environment variable using Administrator client in QA project. Or you get them to adapt the DSParams file in the QA project so that it contains the new entries from the dev project's DSParams file. I'd prefer the first approach, since I have a funny feeling that...

probal wrote:In oracle u can do it.

I happen to know that U is working in a DB2 shop at the moment.

The second person personal pronoun in English is spelled "you", not "u".

Try Look first in the directory from which you executed istool.

This is not the same issue and really should be a different thread.

Meanwhile research APT_STRING_PADCHAR environment variable.

Again it's how it works.

Find out what the character actually is and whether it is correctly handled by the locale and map you are using for DataStage, then make sure that the NLS_LANG setting for Oracle is compatible.

Check with Dennis James (editor@dsxchange.com). Dennis has a zillion contacts.

The "skip job #1" piece is an inbuilt capability. Select the "include checkpoints for restart" option in job properties of the sequence and recompile. The one before another is managed simply by having (dependency) links between activities in the sequence.

You naughty man!

I'm sticking with version 1.5.

This question came up at IOD EMEA 2010. Via RSS from developerworks came mention of COMPARE_PL action (compare longest prefix), which would pick NORTHWEST rather than NORTH out of NORTHWESTTERRITORIES. The question is whether there is a comparable action for comparing the longest suffix. One would g...

Your data is not clear (wrap in Code tags), your specification less so.

Please describe in English the rule(s) for generating the expected output.