DSXchange

This usually occurs after the previous run aborted, and simply means that there were some events stored in &PH& that were not transferred to the job log during the aborted run. Shouldn't happen when the job does not abort. If it does, then you *should* have some messages from the ODBC driver...

No applauding emoticon, but there is a separate forum for heaping praise.

Anything that generates a non-fatal error or warning, or even an unusual event occurring, can cause a job to finish with status DSJS.RUNWARN. Metadata mismatch can occur at either end. Constraint violations can occur when writing to the target. Data truncation can occur at either end. I don't believ...

What makes you think this is the wrong forum, Narashima? The OP has posted quite a few QualityStage job questions recently. And QualityStage forum still forces the choice of server or parallel when posting.

Both sets of error messages indicate that you're running out of disk space. If you're trying to write to a Data Set, File Set or Lookup File Set that's the disk resource defined in the configuration file; if not, then it's the file system on which your file exists. The solution: add more disk space....

How long is a piece of string?
How long is another piece of string?

You can configure the maximum memory (per partition) that the Sort stage will use (by default it is 30MB). Any more than this spills to the scratch disk nominated in the configuration file. Partitioning is irrelevant, except that a poorly chosen partitioning algorithm (for example one that forces al...

Or Search this forum. You are not the first to have encountered this. There are other SYS tables on which you require SELECT privilege.

What are the timestamps on the two "starting job" log events?

Then please mark the topic as Resolved.

With impunity.

Set the format for Quote character to match the quotes on your character strings. Numeric files will be expected not to be quoted.

There is no "multi select" capability in the Export dialog's drop-down lists. On the Options tab choose to export individual components or categories. To export a second category, or a second infividual component, you need to do a second export, this time with the Append check box checked. Or you ca...

Different in different countries.

That's not an FTP error. That's DataStage advising that it's giving up.

You set up Specifications. Each output column must have a specification. You can have a KEEP specification to pass through column(s) that do not need to be modified, or a DROP specification to manage column(s) that do not need to be passed through, but not both. Every other output column needs a Spe...