DSXchange

:? Umm, ok. I only asked because people sometimes search for too many words at a time. There's also an issue with the search here that only an Exact Search returns results from the beginning of time, the others seem to be time limited, meaning if what you are looking for is more than a few weeks (?)...

In my experience, projects are created to support subject areas, logical groups of jobs - regardless of the number of jobs, unless that number becomes VERY large and unwieldy.

Set your Array Size property to 1. Not sure what other advice you were expecting.

Of course, you could stop using that combo action.

You need to post an actual question and provide details of your issue. All we know right now is you ran a script and it returned a '2'.

There's no effective limit on the number of projects unless the number of directories it creates becomes an issue (AIX). The number of jobs is more of an issue and that mostly just a 'how long it takes to refresh' in the client tools.

So your lookup is failing on the first run. Since it succeeds on the second run with the same data, then it doesn't seem like a key matching / trimming issue. Sounds to me like you'd need to concentrate on the 'caching' aspect of it, why a write to the same hashed file isn't available until the next...

Sorry, not 'removed' but meant to say 'reused'. D'oh.

OK, you seem to have covered all of the bases: 1. Reference hashed file is not cached. 2. Write link is to same hashed file name. 3. Only needs to be in the same transformer when 'locked for update' is used. 4. Write link not cached, not set to clear the hashed file. 5. Any clear of the reference ha...

Otherwise just add 2000 or 1900 for a numeric solution.

So what stages are you using in your job? And this sum() you are fetching is using a 'group by' in your source sql I assume, yes?

Not really an answer, per se, but do you not realize that the order you mention those columns in your DML will make absolutely no difference to the result?

There isn't a way that I know of, except perhaps to export / edit / import the dsx. I think I just got really good at the R-R-Enter-DownArrow key sequence. :wink: ps. I prefer just 'Replace' without the pesky warning unless you really need to know that field is missing and possibly abort the job if ...

Realize that he said it may do so, not that it does. Hence the suggestion to check with support.

I would take those questions back to IBM, if I were you. That or your official support provider.

Right, that would be the 'fork join' design that John Smith mentioned in the first reply here.