DSXchange

Welcome aboard. :D Since you are running on a Windows platform you also have available the SQL Server Enterprise stage. However it is not possible to run parallel jobs on Windows version 7.5.1. You can design them, but you can't run them. You need version 7.5x2 to be able to run them in the parallel...

dsadm belongs in any group you place it in, and this does not affect its definition as DataStage Administrator. Apart from that DataStage security works by assigning DataStage roles (of which there are three, operator, developer and production manager) to operating system groups. This is done on a ...

I prefer my way of avoiding double quotes! :D

And the 1024 is a typical network packet size.

Why bother? If you are going to process all of this, simply add a constraint early in the job that skips that final empty line. Set your "missing field" properties appropriately.

It's used however you want to use it. DataStage merely dumps the data.

Whatever answer is posted to that question will become out of date. Check the IBM website for a current answer.

For running parallel jobs on Windows, 7.5x2.

Welcome aboard. :D

A tantalizing question. Like Arnd it's not something I've attempted. Why not try it and let us know your findings?

Almost certainly no.

It cheats. When you install 7.5x2 along with everything else it installs MKS Toolkit. It uses this as its UNIX for running osh. However, you still need a C++ compiler to have been installed in order to use the parallel Transformer stage, BuildOp and so on, in this case the Visual Studio compiler.

Unable to reproduce this problem using 7.5.1 on Windows 2003 Server. Round robin partitioning went fine.

It's not possible. What I do as standard practice is to place an EQUATE declaration at the beginning of every routine. Equate RoutineName To "MyRoutine" This behaves like the macro you seek. Because it's at the top of the code, it's obviously there needing to be changed when the code is co...

Pass a timestamp in to the job parameter or, if proc_dt is also used elsewhere in the job, provide an additional parameter containing the timestamp and use that as the file name suffix.