DSXchange

Source file Arnd.

No.

Did you import the metadata for this procedure? Did you define all of the output columns or just one?

It also supports being a target and dynamically changing the output filename based on data on the input link. That's the draw here where the number of files needed and their names are not known ahead of time.

Others would have to confirm but from what I recall that was an issue in "older" 8.x versions that was subsequently corrected.

What version of DataStage?

Use an External Source stage to deliver the filenames, not a Sequential File stage.

One way - stage variables to take the first group per project / year, hence the suggestion to sort descending.

Thought about this on the long drive to work... and was going to suggest the same thing. Thanks for the save, Ernie.

Max(year/month) comes to mind but that won't get you the appropriate sum. Seems to me you'll need to find a way to send only those max records to the Aggregator. Sort descending with a key change column and take the first group per year, perhaps.

I've set property Source Type= "Database sequence" and I used SKG with Oracle sequence, previously created thru SQL script. I believe that if you check the documentation, you'll find that DataStage must create the Oracle sequence rather than being able to leverage one you created 'thru SQ...

There's no DataStage limit.

Thanks Craig for looking into, If I understood correct, you are implying that the issue is with DataStage NLS and need to reinstall DS with NLS reinstalled. Well... I was specifically trying to not imply that need as basically I don't know if that is the solution. And yes that choice to 'install wi...

Probably related to how it writes out records, as noted in the documentation they are "delivered in a single column" - a LongVarChar. However, what happens if you sort the output by City first? Or have you?

Correct, there's no "converting" in any sort of automated sense. You understand what the BASIC is doing and rewrite it in C++.