DSXchange

Support.

Others will need to chime in here but I'm not aware of any way to make that Array Size in the stage 'dynamic', so thinking you'll need to handle whatever passes for the maximum number of records to pivot to columns. I wonder if transformer looping would be a better option here? And then it seems to ...

:idea: People, please make use of the Preview option if you are posting something that you expect to look a certain way, like the examples above. Then you can perfect them and make them actually usable rather than making me do that. The forum software removes all 'extra' whitespace so if you want to...

LOL

Okay... the view would hide all of the looping / iterations / grouping shenanigans from DataStage and just look like a straight select from a single table so seems to me it shouldn't really need to be any kind of 97K characters huge... but okay.

Can you put a view over all that, source from the view instead?

Not really... does it really need to be user defined? Curious also what you mean by "loops" in the SQL.

Then that should be pretty straight forward.

Wow, that's still going on? From what I recall, it does stash them somewhere so cron has access to them but don't recall the where. And I seem to recall a change to a schedule possibly triggering that so we would delete and recreate it instead. Sorry, got nothing else except this right now: :? I thi...

That doesn't sound like any kind of a summary. Use whatever you are most comfortable with to create the summary - Server job, Parallel job, script - if your rejects are plain text files than any of those could be used. And IMHO create one file with a summary of all rejects and attach that, the Notif...

Seems to be an issue specific to Windows from what I could find.

Involve support.

Not sure there's any need for a "routine" quite yet. A Sequence job can easily be used to create a file and then email that as an attachment. I think we'd need to know a bit more about what you mean by "a summary" to provide more help. If your reject files are all datasets then y...

Out of curiosity, what kind of "processing" do you need to do with them?

Can you be more specific about what "not working" means here? If you are getting an error, please post it. Both of those are perfectly valid DOS/Windows wildcard patterns that work just fine from a command line so not really sure why they wouldn't as a File Pattern. SRS_????????.csv SRS_??...