DSXchange

It usually tells you what the invalid character is (for example 0xBA or 0x8D). Did this occur in your case?

So the secret was "non-contiguous" rather than "tens digit"?

Do you understand what a segmentation violation is?

You can inspect the score to determine whether operators are inserted.

I happen to know they're on Linux (but not sure about which version).

Can you link the databases in Oracle and use SQL?

I would expect Iconv() or Oconv() would be used with server job stage types to effect unmasking of decimals and various other conversions. So, yes, even if you're using OCI, it may be so. Check with support, though they may decline to answer that particular question.

(... theme from The Twilight Zone...)

Write it out in English first. This is always a good idea, as it focusses your thought processes. For example, is the break every third row, or the tens digit of NUMBER, or something else? Once you've figured that out, and documented it, you will have your transformation (source to target mapping) s...

Unless there is explicit sorting on its inputs (namely a Sort stage or input link sort), the Join stage will have tsort operators inserted. Whether or not there is sorting does not affect whether partitioners are inserted; this is usually driven by whether or not the partitioning algorithm is set to...

PICKNULL only relates to Iconv() or Oconv() functions. However, these can sometimes be implicit - for example when using the ODBC stage, and data element of Numeric or Decimal.

:D Craig has it, ladies and gentlemen!

Try putting the date in in exactly the format given on your licensing documentation. If that doesn't work, try YYYY-MM-DD format for the date.

Let us know if that information resolves your problem.

Welcome aboard. To connect you must provide, in the top field, the name of the Information Server domain host followed by port number 9080 (for example DomainHost:9080. Once you have done this, you should be able to choose a DataStage server/project combination from the drop-down list, provided that...