DSXchange

You should'nt have to reload them. I don't recall off the top of my head, but there are commands you can issue that will upgrade either a job or all jobs in a project. Support will be able to give you the command.

Write to a .csv file instead. They can be 'automatically' imported into Excel.

RCP.

Check the post Arnd linked to, three posts up from yours. It explains the process.

Search is your friend! This post seems to have the information that you need. There were others, btw.

From "back in the day" when I had to deal with Lotus Notes as one of my sources, there is also a product called NotesPump that we used. I only mention it for completeness as it doesn't allow you access to Notes data directly, but can be used to 'pump' or push Notes data elsewhere that you do have ac...

Nope... DataStage XE is the 'official' abbreviation for the Extended Edition. From what I recall, it contains just the Server product and MetaStage. I'm not sure they market that particular flavor of the product anymore. And actually "PX" is part of the Enterprise Edition, not the sum total of it. D...

Is there any other approach to this problem without using lookups. No, not really - if we're talking a pure DS solution. Any output column will be updated in the target with whatever value you provide. In order for you to allow the value to remain unchanged in certain circumstances, you'll need to ...

Hmmm... can't say that I've ever had a need to do that, so haven't looked for a way. I'm sure someone has, though.

What are you up to, Arnd? Curious about the why of your what.

Welcome! :D

lata walekar wrote:Is it possible to set the parameters of a job from its before routine itself ?

Short answer is no. Stick with your 'server routine' which I assume means via a Job Sequence.

Reinstall the client.

It basically means you've created a loop in the job and without discrete beginning and ending stages the job 'will not run'.

yiminghu wrote:But business wants more detail level aduiting, they want to know which individual input row end up ?

Can you shed some light on exactly what this might mean - "Which individual row end up"?

I'd definitely recommend you look into setting up a Citrix server local to the DataStage server and installing the Client software there. We just did exactly that and it has helped our 'remote' folks tremendously and even those of us connecting via VPN from home get a great benefit as well. For exam...

I'd also be curious if your design is to 'clean' a single table? In other words, are you sourcing from the same table you are clearing? I know it sounds silly, but I've seen people try to do that - they will only write back 'the records they want to keep' - hence the question. And if that is the cas...