DSXchange

This isn't really a server job, is it?

The message stated "delimiter not found". Check that the field delimiter in the table definition (record schema) matches that found in the file. You need to get that right before trying anything else. Is there any information in the first part of the record indicating its record type (format, number...

Do some detective work. Add a routine activity (UtilityMessageToLog) to report what actual value is being returned in $CommandOutput. Convert the field marks to something printable, for example Convert(@FM,"~",ExecuteCommand.$CommandOutput) You may be extracting the incorrect field...

I'm sure there's a solution possible in DataStage, probably involving Transformer and Remove Duplicates (keeping last) stages.

Take/make time to read the installation and upgrade manual, and any additional documentation that accompanies the software, very carefully. Plan the process. Know the questions that will be asked by the install script, and have your answers ready. Make sure there's enough temporary space for transfe...

No it doesn't. It means that the file was created on a Windows machine, was transferred to the UNIX machine without translating the line terminator characters, and is now being processed on the UNIX machine.

Involve your support provider. If FTP Enterprise works differently from FTP plug-in stage - provided everything is configured identically - then you've probably uncovered a bug.

The FTP utility used to transfer the file may have effected translation from EBCDIC to ASCII.

What do you mean by "NOR REQUIRED"? The message indicates that a particular column is not in its expected position. This might be a failure in generating ABAP code (check the code), a rogue row in the table (check the table) or a metadata mismatch in your job design. Because it works sometimes I thi...

Have you followed all the instructions in the manual about configuring and testing the rsh (or ssh) processes? Have you opened the firewall to the port numbers used for communication by parallel DataStage processes (from memory 10000 (APT_PM_STARTUP_PORT) and 11000 (APT_PM_CONNECTION_PORT)?

The message informs you that no wait was required.

There are two slash characters in the pathname '/data//HASHED_M_STATE' - check to see how you are generating the pathname (parameters) and how the second slash comes to be. Perhaps the job parameter for the directory has a trailing slash and the constructed pathname in the stage has a slash between ...

It's always called DataStage. The individual product codes specify for which particular operating system it is. Your vendor has access to the relevant information. You can determine what's available from the IBM web site, if you're really interested. Beware that there are also version dependencies; ...

Find out who created the expression and ask them! Looks like a clumsy attempt to force an implicit conversion to string so that the Trim() function can be applied. But it's wrong. The proper way is to use an appropriate conversion function, such as StringToDecimal() in a Transformer stage or string_...