DSXchange

One of the significant features of Advanced IBM UNIX (AIX) is, indeed, its self-tuning kernel.

Look very carefully at the percent signs in the error message.

You can specify a global Null Field Value on the Format tab of the stage but may need to override this for particular columns by editing their extended properties.

will also return the final character. I prefer this approach as it's more "self-documenting" than the esoteric use of the substring operator.

Learn from the experience. Always manage your metadata rigorously.

The only issue is that you will need to convert the 7.x instance to using an 'itag' (a non-default shared memory key) because 8.1 must use the default itag ("ade").

You can only have one version of the client active at a time.

No.

I understand that IBM will shortly have "What's New" presentations for DataStage and QualityStage 8.5 but have not yet seem them (so can't comment on content).

I don't know what you're asking here - you've asked how to do something then described a solution that works. You've also marked the question as relating to a server job yet posted it in the Enterprise Edition forum. This is like asking your greengrocer why your blood pressure is elevated.

Date data types don't have a format, so all you need to do (assuming the source is a text file) is StringToDate() function.

James suggests that you eliminate single quotes from the source data - a good idea if they're there.

What delightfully meaningful activity names!!!

What job does Job_Activity_151 run? That's right - TestJob_1. You appear to be attempting to run it twice. The second attempt probably fails because TestJob_01 is not in the right state because it is already running.

Demand to know from the client.

After all, DataStage is a graphical tool - THERE IS NO CODE!!!

The problem when you execute an operating system command is that every line is terminated with a linefeed (or carriage-return linefeed if on Windows). When DataStage retrieves the output from the command it converts all line terminators into a special character called a field mark, the value of whic...