DSXchange

It's wrong. You're wrong. (You did request that.)

It's illegal to have more than one process write to the same sequential file.

This is not a DataStage rule; it's an operating system rule.

So what you want doesn't come into it - it's not possible.

3.0 came out before 2.5.

There were good reasons. 2.5 was 2.2 with NLS, 3.0 did not have NLS. NLS was new at the time; 2.5 spent longer in beta then planned.

The numbers are there for uniqueness, just like surrogate keys.

I hate that. It generates a warning in the job log. My idea of best practice is that no job that executes successfully generates a warning.
Prefer a second output link whose constraint expression is the logical inverse of the constraint expression on the "good rows" output link.

Did you search for the answer? You would have found this routine. FUNCTION SetUserStatus(TheValue) Call DSSetUserStatus(TheValue) Ans = TheValue RETURN(Ans) Invoke this in any column derivation that's not doing anything else, with the stage variable name as its argument. Or m...

You can design using any version of DS EE (from 6.0) on Windows 2000.

You can not run any version of DS EE except version 7.5x2 on a Windows platform, and it is only supported on Windows 2003 Server. Some have been able to get it to run on XP Pro, but that is not supported.

When a DataStage client requests a connection the request is for an instance of the dscs service and is handled by the DataStage RPC service (daemon on UNIX), which runs as dsrpcd . From the dsrpcservices file it is determined that the executable needed to provide this service is dsapi_server.exe so...

MFILES should default to 200 on Windows, which ought to be ample. Of course, you can monitor it, and increase it if it isn't. On UNIX systems it should be set to a value eight less than the value of the kernel parameter NFILE (number of file units that a process may have open). T30FILE usually does ...

One value can be loaded into the job's User Status area. This value can contain anything, including a delimited string, by which means it can pass more than one actual value. A job sequence can access the job's user status area conveniently through the job activity's activity variable $UserStatus. O...

These warnings probably should only be informational messages; they indicate that certain power-of-two threshholds have been reached for the size of the in-memory table associated with keeping the intermediate results for the Aggregator stage. Access to the rows in this table is via a hashing algori...

I am not aware of any tools, in either direction. One of the reason for the lack is that the two products take a different approach to solving the task of ETL - simplistically, DataStage takes a "top down" approach (draw the picture, then fill in the details), while Informatica is more "bottom up" (...

Ray,
It will cost about 675,000 for EE and 230,000 for Sever edition. Do you think is it worth to pay so much more for EE?

How long is a piece of string?

If you want the right tool for your circumstances, you buy the correct tool for your circumstances.]

You can do this using ExecSH as an after-job subroutine, or through an Execute Command activity in a job sequence. Or, if you're running the DataStage job(s) through dsjob, you can incorporate the cat command in the same shell script.

Search the forum for what it means.

Then stop overloading your machine.

The main errors are between the keyboard and the chair.

Make sure you have a backup and an export.

Shut down DataStage.

Install the new point version of the server.

Restart DataStage.

Reinstall clients when convenient. 7.5 clients will talk to a 7.5.1 server.

If you create your batch as a job sequence the job names are automatically stored on the Dependencies tab of job properties. I don't know whether this is also automatic for batches (created in Director) but, if not, follow Kim's suggestion and record them there.