DSXchange

For a fixed-width file? I think not.

Yes and I recall several posts here on the topic. Searching for something like "wall plug" may turn them up. Generally an "out of memory" error from what I recall, which is why a restart can help.

Split out to your own post.

This may help as well: viewtopic.php?t=127425

You may need an 'alter session' Before SQL to ensure that the session timezone is set correctly vs. the timezone on the db server.

pandeesh wrote:Finally take the last record from the transformer using tail stage.
Make sure your transformer is running in sequential mode.

FYI - Neither apply to Server jobs.

An identical post is here: viewtopic.php?t=143867 and we even get the same unhelpful subject.

Why in the blue blazes did you feel the need to start this conversation up all over again?

There must be more to the error than that.

I'm not sure why you quoted me Because the 'Reply with quote' option is oh so conveniently positioned right up where you can't help but click on it. You'd be shocked how many people don't think there's any other option. But that keeps me off the streets - part time Moderator and part time Janitor, ...

This particular error has nothing directly to do with a target table, size or otherwise. It is strictly a DataStage message for an output link with the 'Abort after rows' property set to something other than zero... when that number of rows have been sent down it.

I've tried to help Eric several times but my cries seem to be falling on deaf ears... that is some sort of setup issue/error and needs to be resolved by the site owner / webmaster. Sorry.

As noted, make sure your 'list of things' you are iterating thru have a proper delimiter between them, one that doesn't occur in the data.

Moved to the proper forum.

Please go back and edit your post adding in the missing information - Version, Job Type & O/S.

What 'certain data' exactly? Are these COMP-3 / PACKED DECIMAL fields?

Or you can figure out the why of it and handle it properly. Perhaps you simply need to tell it you have a DOS file?

And yet you said "but I don't agree with that". Color me... confused.