DSXchange

Lose the repartitioning by moving the partitioning to the inputs of the Modify stage especially in a multiple-machine environment. For larger volumes, reading the second file into a Lookup File Set may help. So might multiple readers per node. I take it that the delimited file format is a given? Fix...

Check that you are supplying the invocation ID correctly. There does not appear to be an invocation ID in these messages.

Welcome aboard. VMark Software produced versions 1.0 through 2.2. It then became Ardent Software through a merger. Ardent Software produced versions 3.0 through 5.2 (and 2.5). Ardent Software was acquired by Informix which subsequently split into two; one half (databases) was sold to IBM and the oth...

Your first statement is incorrect. RT_LOG is only a prototype, and is empty. Each job has its own log (hashed file or, if you prefer, table) called RT_LOGnnn, where nnn is the job number recorded for the job in DS_JOBS. But these all use identical metadata. That is, there is only one "kind"...

Attention to detail!

There is no function called "isvaild".

Further, your assertion that the "proper" format of dates is dd-mm-yyyy is only correct if this is the default date format string.

No, it treats #ME_FTP_DIR# as a file name, since it's not a job parameter.

Does U work at your site? If not, why mention him in your documentation (comments)? If OpenSeq takes its THEN clause, the loop variable is never incremented. As already noted, it's never given an initial value either. You are relying on "nice" behaviour from the engine: "variable unas...

It appears that you are trying to export with the job open in one of the clients. There should be a warning message indicating that it was skipped.

Release the lock on this job and you should be able to export successfully.

At worst, re-start the DataStage server.

It's an alert message. Not every dfloat number can be represented as decimal[13,2]. The key word in the message is "possible". If you are 100% certain that all your data will fit, then you can ignore this alert message.

The figure that DataStage reports is the number of rows that it sent to the application. If your third-party application has discarded some of those I would expect it (the application) to have its own logs. If this is a custom-written plug-in stage type, its author may or may not have provided for d...

This is downloaded from your vendor in exchange for money. It tells the installer what products you have licensed.

Each instance is logged separately, at least logically (the entries are all in the same table, but each is inspected through its own "view"). You open each instance's log in Director.

This is what's called a "vertical pivot". Please Search DSXchange for techniques - the most frequently recommended uses stage variables.

Create a Notes user that has no password, then use that.

Do a search on SETFILE.

I normally use ExecTCL as a before-job or before-stage subroutine. The command executed is: