DSXchange

Sorry but there's no such thing.

Out of curiousity, what exact 8.x version are you running?

As a guess, I'd think your /tmp space is filling up. Is it being monitored?

Split to your own post.

How about you include the details of your error?

The Execute Command stage just runs operating system commands. To "read" a file one would generally just "cat" it and then check $CommandOutput for the returned values.

Yup. As noted without any buffering involved each row is processed from source to target, one after another.

Ah... nope, sorry, wasn't thinking it through from a "full IDE" standpoint more just from editing and syntax highlighting. Still have to paste it into DataStage for everything else.

Not sure such a thing exists.

Split to your own post.

I used UltraEdit.

I never mentioned the SQL Builder in my post, I found it generally awful. 'Generate' meant from the metadata on the fly which I believe all stages support. Parallel jobs are probably more picky on the whole 'missing columns in user-defined SQL' issue but Server jobs? Not so much. I've seen column mi...

I'm not aware of any limit.

Exactly. Do it when you need to otherwise let the stage do the work.

This information is already posted here. #2 is incorrect or at the very least way too generic. And yes, you can compile Sequence jobs.

Gotcha... thanks.

You are right, it's not any kind of a performance issue. To me it's a Best Practice that I enforce as more of a maintenance issue for the people that come after us. Say there's a table change and new columns are added to a table, when someone goes into the stage and adds the new columns, the generat...