DSXchange

Job parameters are resolved when the job starts. Until version 9.1 (except for the Folder stage in server jobs) you can't name files based on anything in the data.

I don't believe it is correct, but am struggling to remember back to 8.0. As a general rule, though, a stage that is marked as parallel executes in multiple processes one per processing node defined in the configuration file.

(What Andy said plus) not even if you're using a Microsoft operating system!

It's possible that one or more of the hashed files in the project became corrupted when the disk filled. Execute the following commands from a dssh environment or the Command window of the Administrator client for that project. SELECTFL ACCOUNT.FILE.STATS ALL LOCAL LIST STAT.FILE The first command s...

There is no such option in the Join stage.

But first verify (in the job log) that #File# is being passed correctly to the job.

Try blocking also on NYSIIS of primary name and initial of first name.

You need to reduce the number of records per block. Usually the way to do this is to add one or more additional blocking columns. Think about the implications. If you have 10,000 record in a block, then you have 10,000 x 10,000 (10 million) pairwise comparisons that have to be made, just for that bl...

You need to test the web service itself from some other kind of client to determine whether there's a limit on the rate of updates that the service itself can perform.

Use values files to provide different sets of defaults for different circumstances (in your case for different years).

If you make the parameters all environment variables you can create default values in the Administrator client.

A routine that returns a non-zero value will trigger the automatic "error" handler in a sequence. Add an explicit Failure trigger to bypass this handling,

The boost libraries aren't the problem here. The problem is that DataStage cannot find the library/object that was created by compiling the Transformer stage (probably because its parent directory is not in your library search list). It (the Transformer .so file) should be in ./RT_SCnnn, where nnn i...

You must add it individually to jobs unless you make it the default message handler for the project. To make a message handler the default for the project you need to use the Administrator client, and go to the Parallel tab in the project properties. You can select one from a drop-down list of named...

You must perform the comparison before the "remembering" stage variable is executed. svCurrentValue <--- input column svIsIncreasing <--- (svCurrentValue > svPreviousValue) svPreviousValue <--- input column (You don't actually need svCurrentValue.) Use the value of svIsIncreasing in your c...

DataStage does not tolerate spaces in column names. There is no way to avoid changing name at source; DataStage does not recognise quoted identifiers, square brackets or any other convention.