DSXchange

Export of a Job Not possible from UNIX command line, but possible using dsexport from the Windows command line. Log Not directly. Each job log is a database table, and you need to know the job number associated with it. If you do, you can invoke a dssh command on the server containing appropriate S...

You either want Cartesian products, as one reading shows, or you don't, as another reading shows. But there is no way to "avoid" Cartesian product if what you need is the result of a Cartesian product.

Excel does have a Track Changes option on the Tools menu.

But I agree with Vincent. We saw FastTrack at IOD 2007, and it looks "the goods". It will even generate your DataStage (parallel) jobs for you!

Where are you reading the row counts? What happens when you use Monitor, with Show Instances selected?

Beware that this is still in draft (pre-release) form. The actual RedBook is due out at the end of March 2008.

Do buy a premium membership. There's a lot more to my answer, without which you are in danger of making some false assumptions.

What happens if you import one of those 7.5 jobs into 8.x ?!!

You don't refer to $PROJDEF in your job design. You set up a regular job parameter (environment variable). Let's assume it's called $MYDIR. It is set up in the Administrator client and given a default value there. In your job, you add $MYDIR environment variable as a job parameter, and set its defau...

Not having access to EE at the moment, I ask whether you can draw a reject link from the SQL Server Enterprise stage? If so, the SQL error code should automatically appear on it. At least, that's how the Oracle Enterprise stage does it.

Have you searched the forum for it? This post for instance?

I observe that 7 is approximately 32 / 4, so the figure of 7 you are reporting may be for one node only.

Did you Search, both here and on the IBM web site?

Stages (operators) run (possibly) in separate processes. Therefore the variables available to one are not available to the others.

What about stage variables' data types?

I'll be partying all weekend - my baseball club's 50th anniversary.