DSXchange

ray.wurlod wrote:But, and it's a big but, why do you want to write code to do what DataStage can already do?

Just wanted to make sure Ray's Big But was shown to the public.

Still... couldn't hurt.

Weird, never seen that before. Suggest you reinstall your client.

And for myself, I prefer to never link two passive stages directly together. :D

OR just get rid of it, the 'as XXX' part is completely ignored.

Why 'lose the transformer'? DataStage will just 'put it back' under the covers and I'd rather put it there myself, even if it 'does nothing'. Try both ways, let us know. I've generally found that taking the time to land the file first and then load from that flat file is actually faster than going s...

One of the first things I said - hope you have a backup - for exactly that reason.

Actually, it's an RTI question, so should be in the SOA forum... that's what controls the load balancing. I've never set it up, not having more than one of anything yet to work with, but it's all explained in the RTI Administration manual, from what I recall, and in the online help.

What the heck do you mean by 'suppress the return status code'? You can return whatever you want from the script but can't 'suppress' it - it needs to return something. If you don't want to send back anything from dsjob - don't.

It's only valid for Static hashed files, guessing yours is Dynamic.

Have a (url=http://dsxchange.com/viewtopic.php?t=100006&highlight=dsjobs+dsjobobjects&sid=651bb606acba5eba6916a5bd82f8e8da)look(/url) at this discussion regarding the renaming job. Kumar - you cannot post links from your search results, they won't work for anyone else. See how it has a '&am...

Alagusakthivelan wrote:But the CFF stage can be used for reading purpose only, it wont allow to write into it.

Really? Can you tell I don't use it?

That's too bad.

Post your target sql... the two don't match, plain and simple.

You think? Post your target sql.

And?