DSXchange

... or at least disabling your antivirus AND FIREWALL (or opening the ports that the product uses, primarily 31538).

What is Search?

The problem is in your script, which exits with a status of 1. DataStage assumes that a non-zero exit status is a failure, since this is the convention followed in all shells. If you want to make sure that this does not occur, make sure that your script exits with a zero status if the script does no...

What you seek to do is cumbersome, though possible. The dsjob command includes options for reading the job log; you must provide the project name and job name whose log you wish the command to access. To get the job number associated with a job name from UNIX (which you don't need to use the dsjob c...

Please mark as Resolved using the green button at the top.

Probably easier to uninstall and re-install the client than to try to diagnose. If you don't want to do this, involve your official support provider.

Please back this kind of assertion with empirical evidence. That is, create both kinds of job and take measurements. You may be surprised.

parag.s.27 wrote:as a performance improvement task, we are replacing all those transformers those are performing operations that can be handled by another light weight stage.

You are right about the foreign key. Prefer generated SQL - it will always match the number of columns in your job design. If you want to update all columns then you must mention, and provide values for, all columns in your job design.

Leave out the sh -c and the double quotes.

Disable operator combination so you can discover which stage is throwing the error. You are running out of scratch space, and there is at least one short record in your input data. This can be discerned directly from the error messages.

I will be staying at the Sunnyside Park Hotel, Prince of Wales Terrace, Parktown. Please get in touch by PM or email if you'd like to say hi while I'm in country.

Without knowing how you define performance it is impossible to answer your question. The stage types do different things - a Join stage performs a join, a Merge stage effects a Master-and-Update mechanism.

ODBC messages always have a string of entries in square brackets at the beginning. You can read about them in the ODBC API manual (Microsoft Press). For example [ODBC] indicates the ODBC driver manager. [Data Direct][ODBC lib] specifies that the driver library supplied by vendor Data Direct was invo...

Yes, New OR Enhanced was the heading. Pivot stage has been enhanced (though one presentation had it as new). Still horizontal only, still "watch this space" for vertical pivot".

CHAR is the same as Char(1) is the same as string[1]