DSXchange

Do you have authority from the data owner arbitrarily to delete some of the characters in their data? (There are no "junk" characters.) If the data owner needs to have particular characters removed, the "double Convert()" technique is recommended. Otherwise you have to work out h...

This is an Oracle error (-24806), not a DataStage error. The error is generated from stage TABLE_XYZ, so you can tell from that whether it's the source or target.

DataStage 8.0 needs to be installed on Windows NT 4.0. Neither is supported.

DataStage can not "interpret" anything. All it can do is compare two strings - encrypted or otherwise - to determine whether they are the same.

That is not what your example shows.

In the Remove Duplicates stage specify your "all columns except Start Date".

For that to work properly, you need to have sorted on all columns, and partitioned on at least the highest level sort key.

Can you explicitly set the extended property "Unicode" for each character string?

What is the data type of the final field? If it's VarChar, then a length mismatch will be tolerated.

Although it's still using the operating system (or a routine), you can write the header in a before-job subroutine then, in the job, append to the file.

Only if you have the decryption algorithm.

DataStage can be used to compare encrypted strings. That is, one encrypted string with/against another encrypted string.

If the lookup fails and your Lookup Failed rule is "Continue", Col2 will be null - you don't have to check for "" unless Col2 = "" is a possible valid return value that you need to handle - this is not the case in your example. Indeed, NullToValue(InLink.Col2, "~&q...

Try using an explicit CAST in the SELECT statement to force the database to deliver you a LONG VARCHAR.

Is one of those records the header line and you have "first line is column headings" set?

Does this indicate that your problem is resolved? If so, please mark this thread as Resolved, to assist future searchers.

How heavily loaded is your system and, in particular, are there very many logging events occurring when the reported failure occurs. The fact that the Logging Agent cannot establish a(nother) connection suggests a transient lack of resources.

The Execute Command activity executes a command in the operating system, in this case Windows. To execute MKS Tookit commands, its bin directory must be named in the Windows PATH environment variable. Another approach would be to name a UNIX shell explicitly in the command you are executing, for exa...