DSXchange

No error or warning message from UVFIXFILE proves that no corruption was found in any of the (hashed) files processed. It is important to eliminate corruption as a cause of your problem. Re-reading the error message, the corruption is actually in job number 807, so it is these commands that were nee...

No.

It's how "they" implemented it. Ask "them".

The JD Edwards date format is not a Julian date in any case.

Have you read the manual or online help about DSSendMail? What's in the BAT file? Have you customized it? Did you supply all required parameters in the argument to DSSendMail()? What delimiter character did you use in the string?

You misunderstood what I said. The log is purged only if the current run finishes successfully. It does not matter what kinds of entry are in the previous runs' events. The log is not purged if the current run aborts, or is a Validation run.

This is another advantage of using external FTP script; you get a local file. You can use the command tail -1 filename to get the last line from this file. Yes, it's a UNIX command but there are various "UNIX on Windows" packages available. Or you could create a routine that reads every line and ret...

Yes it's a big IF, particularly in a team of more than one developer. However, it's a problem that can be avoided if you make it known that you have a baseball bat ready to hand.

You need to apply a vertical pivot to the joined data (which contains multiple rows per CUSTNO). Search the forum for vertical pivot; there are several techniques available. Pivot stage is not one of them.

If it's 7.5x2 you have MKS Toolkit and can therefore use UNIX shell scripting, including a here script to serve the telnet command with authentication details and any other sub-commands. This was alluded to earlier but not much explored.

I doubt that the form If 1<SV<6 is valid; that you need If (1 < SV AND SV < 6)

DataStage can handle a NULL in a Char(N) column, but the value that is used to represent NULL must have exactly N characters. Such is the definition of Char(N), surely?

Not with so sparse a description. WHAT special values? Are the columns nullable? What are the data types of the affected columns? What values are in the source data? What transformations are being applied?

Position your mouse pointer over the URL button (without clicking), and one line of help appears above the text field. It shows the two "Insert URL" syntaxes. We use the second one to effect what you describe. For example:

[url=http://www.shibumi.org/eoti.htm]End of the Internet[/url]

Does it compile OK on the server from which it was exported? If so, try exporting it again, with executables, then importing it again. It may simply have been a bad import. A more meaningful message would have been beneficial; you need to report this (if you haven't already) via your support provider.

That makes sense; C does not have a "native" representation of NULL.