DSXchange

Setting the stage to 'Append' is the only way to keep zero records from 'removing the contents'. However, a 'normal' run won't do so either. Perhaps you should use a date in the filename so that each day you get a new file?

Again - where exactly are these 'lists' stored? In a flat file somewhere? Database? Piece of paper on your desk?

Search the forum for your error, you'll find many conversations on what the -14 means.

Long story short - you have overloaded your server, tried to run too many jobs at the same time. Search.

I almost did the exact same thing last night - repost your question in it's entirety.

Uma - why reinvent the wheel? The CFF stage will do this for you automagically.

And you'll need to talk to your SA to effect any change there - you won't be able to directly.

Welcome. How about posting your complete job design? Curious how you are 'merging' the input from three (separate?) ODBC stages for loading via a fourth. Also, any chance that your target table is one of the three source tables and you are blocking yourself? How long do you wait before you decide th...

What are you trying to accomplish here? Seems that you took an issue with a simple solution - the change that Arnd posted - and made things way more complicated than they need to be. You just needed his one command to reset the file pointer to the EOF so you could append, there's no need to read all...

First you said it was a WebSphere transformer stage, now the WebService transformer stage - which is it?

If the latter, is/was the Web Services PACK installed on this server without issue?

Oh... and Welcome! :D

Didn't notice this was your first post.

So... to rephrase... You have a Sequence job that you need to run and pass in different values. I'm assuming you've already set it up such that, if you do this manually, the job parameter(s) are there that you need and the sequential file and database stages get and use them appropriately as you've ...

What exactly is in the shared container? Anything more than just a Transformer? And to be clear, is it a Parallel transformer or a BASIC transformer? You need to install the specific version of the specific C++ compiler that your version of DataStage says that is supported. It's picky that way. I'm ...

That's the answer if the Sequence job itself is what must be started without waiting - and the Sequence is multi-instance. It was hard to tell from your post, but are you asking how to do this for a job that the Sequence itself runs?

parag.s.27 wrote:Is it like DS supports a particular version of DOS

No, it just leverages whatever it is you got. Post your command.

There is a specific topic for DST changes in the General forum, but I'll repeat the official URL here:

https://www.ascential.com/eservice/public/dst.jsp

Isn't there some kind of equivalent to sqlldr's PRESERVE_BLANKS setting? Otherwise, spaces get trimmed and you can end up with a null field. Assuming we're talking Oracle here.