DSXchange

I dont think you need to merge the records. You need to collect them. Just stick a link collector at the end and collect your records. I dont think you even need a transformer if all that your doing is collecting the records. Just pull the records from the Four DB2 stages, have it go into a link co...

You can specify how null is to be represented as a record level property. You can override that at the individual column level using Edit Row (right click on that column in the Columns grid to expose the menu from which you can open the Edit Row dialog).

Probably a Funnel stage.
Or, in SQL, a UNION ALL.

Feed this result through a downstream stages to effect any transformation you need.

In version 8 there is a SCD stage. But version 8 is not yet available, and won't be for some months. And the SCD stage is not/will not be available in server jobs.

If you are using a Notification activity in a job sequence this error results from not supplying a sender and receiver email address.

Wherever you installed the DataStage client software go there and look in the Docs folder where you will find all the manuals. For example:
C:\Program Files\Ascential\DataStage\Docs

chandra wrote:from start of job to end of jobs what are all activites runs in datastage.

Whatever you design in.

The user ID reserved for DataStage administrator.

All I can say is that my experience is different. I have never encountered any data corruption attributable to DataStage. Maybe I design differently, maybe I haven't used the DRS enough. Or the Data Direct ODBC driver for SQL Server.

I'm not aware of any. Of course, if you invoke QS via the QS stage from DataStage, then DataStage can report the status of the stage. But I don't believe there's an API for interrogating QS jobs directly. If you run QS jobs via the command line interface you could get the exit status of the executab...

No one is forcing you to use it. Hundreds, even thousands, of users are quite happy with it.

Hi, I want to multiply by 40 each row that comes from the input stage to the output stage I'm using the MF edition Thanks' Guy smadga The edition does not really matter. You use a Transformer stage, and build an expression that multplies the input column by 40,in the derivation expression of the ou...

Are you using row buffering of any kind? This can affect the number of processes.

ProfileStage does not perform cleansing - it is only an analysis tool. You need DataStage, and possibly QualityStage, to perform cleansing.

I prefer to use Sequential Files in staging areas, since they are written to and read from faster than anything else.

Determine the process ID under which the job started (for example in the &PH& directory), and use this to determine whether that process is still running. Verify that that process ID no longer exists, then use the DS.TOOLS menu to clean up.