DSXchange

Could you not use DSExecute instead? What are you trying to run, Tony?

Recently coined? Sorry, Camel Case goes back quite aways. Recently mentioned, perhaps.

This one. Not a business site, but a clue as to how a great deal of my 'spare' time gets spent. What little I have nowadays, that is.

Just thought I'd share this, in case anyone else doesn't know this. I certainly didn't, and had to have it pointed out to me on another board that uses the same software. Sheesh. Anyway, when looking at a list of posts, the new ones will not only have the colored icon in the left-hand border to indi...

Not being sure how much help do you need with this... You are in complete control of 'duplicate key' handling in DataStage. Build the job to accomplish the type of handling needed. For example: 1. Assuming your target table allows 'duplicates' of this nature, do nothing special to allow duplicates l...

I believe you'll need to look into 'remote shell' invocations. Search the forum for remsh or rsh and you should get several hits from people attempting to do something similar to what you've asked.

There's no dsenv file in Windows. Your Oracle information (including the default Home) is in the Registry, which is where DataStage (amongst other things) looks for it.

ray.wurlod wrote:If you're at the UV shell by the means indicated above, you need another step. You must move to your project.

Not if all you want to do is get the HELP entry for DELETE.FILE!

From the UNIX command line you should cd to $DSHOME and then source the dsenv file:


From there, the simplest thing is to execute ./bin/uv and you'll be at the TCL prompt where you can try your HELP command.

You don't, which is mentioned in the thread you linked to. That command is only for objects with a VOC file pointer, and unless you've manually created one for your pathed hash file - it doesn't have one. For those, you simply delete the structures at the O/S level with normal commands, like rm -rf ...

ray.wurlod wrote:So far I've avoided using DSPrepareJob.

Just... because? Seems to be working just peachy for me.

Kim - I use DSPrepareJob which doesn't require me to detach and reattach before I can run it.

Interesting... hadn't thought of doing things that way to use different clients per project - but then I've never had a need to do so.

Still, the answer to the original question is "no".

So, does VC move the objects on server side or does it too bring them first to the client? Being a client tool, it brings things up to the client. You'll see marked differences in performance when working local versus remote, much like you are seeing with Import/Export via the Manager. Haven't had ...

Generally, that can be mitigated by tuning some of the parameters in uvconfig like MFILES. There's been several posts on this here, including this recent one on the concept of the Rotating File Pool.