DSXchange

They look like they should generate a set. What are your cutoff settings? What are the weights generated by your data - both the aggregate weights and the individual field weights? Finally, what parameter did you provide for your name_uncert matches?

Do you have read, write and execute permission in the DataStage project directory on the server?

Do you expect the command output (not the same thing as its exit status) to be 0? Even so, the command output tends to come with line terminator characters, which are translated to field marks that have to be removed.

writeSocket() returned 4

Seriously, though, you have not provided nearly enough information about your job design for anyone to attempt a cogent diagnosis. As well as the job design, it will be important for you to report any other warnings or errors that were logged.

This is not new behaviour in version 8.0. At my current contract I see exactly the same behaviour in version 7.5.1.

Your conversions will not work. The second argument of each is invalid. You can not convert timestamps - you must split them in to date and time components, convert these separately, then re-assemble the result.

IBM still has a training class on the books. It is not regularly scheduled, but can be offered on demand.

Apart from that, the manuals and on-line help are the only extant materials of which I am aware (aside from DSXchange, of course).

I don't see you converting the string to a date anywhere there.
Try wrapping the whole thing in a StringToDate() function.

Probably. But it will be atrociously slow.

This is not a problem and perfectly normal behaviour. The threshold (one of them) is actually 256MB. These "slowdowns" are caused by a "flush to disk" being triggered, in order to minimize potential data loss. If you are using a write cache, increasing its size will change the point at which this fl...

Is the service name ("sapgw00") correct? The error message suggests that it can not be found.

Not errant. I just decided I didn't need it.

Cancel on "Find Next" needs to be included in this enhancement request.

What columns are used to effect the join (the "Key" columns)? On which columns are the partitioning and sorting performed?

dsjob -lstages ProjectName JobName

Search DSXchange. Others have posted full and partial solutions. Chuck Smith for example has a downloadable tool.