DSXchange

Complete overkill to call it more than once and, as noted, it has nothing to do with the status of the job. It's just an area that can be used to stash user-defined information that any other process can retrieve anytime later.

First we'd have to have some clue what you consider "proper format" to be.

More than likely caused by bad user-defined sql where the bind parameters do not match up to the columns defined in the stage.

Nice.

Write them to two different sequential files and then cat them together into your final file after job.

Just keep on going with your transformation. Take that format and switch it around to the one you desire using Iconv/Oconv for the date portion and tack on the time, for example. Then the DIGITS transform could strip out all the extra who-ha you don't seem to want, assuming it is available in PX. Ot...

Define 'header' in this context: the first record of column names? Header as in header, detail, footer records? And do you have the filename as a job parameter or does the job fetch it?

Then please mark the thread as Resolved using the big button at the top of the screen.

Hint: Where are you 'receiving' this file and what is *it* expecting in the way of record delimiters?

Are you su<KA-BLAM!> Dang.

Much like Bilbo, we've already been There And Back Again.

http://www.dsxchange.com/viewtopic.php?t=120983

Do you have the 'Automatically handle activities that fail' option enabled in the Sequence job?

Time to mark this topic as Resolved - big button at the top of the screen.

Ah... redemption. And I assumed the quotes were for illustrative purposes, not literally in the string being passed. Live and learn.

It's an option in the Manager. And off is off, single deletes or 'massive' ones.