DSXchange

Why do you want to do it that way... as an academic exercise? It would be much simpler to leverage your operating system. The BASIC command you are looking for is 'DSExecute' by the way. Or do it from inside a job - there is an 'Append' option in the Sequential File stage, any reason that can't be u...

It's a unit of measure - short for 'crore' or 100 lakhs.

http://en.wikipedia.org/wiki/Crore

gradkarthik wrote:You can run this subroutine as an After job subroutine from your job properties page.

No, you can't.

What exact version of DataStage? I seem to recall encrypted environment variables being broken until recently.

That would be a question for Information Builders, I would think.

From your operating system. Before Job using ExecSH, for example.

Aha! That's true... make sure neither of the 'special' Views are activated: Host View or Extended Job View - then you should be ok.

But I would like to know as soon as the job aborted. So do u have any other idea??? Thanks, You can also schedule a little piece of job control code rather than the job itself and have the job control do all the normal bits - attach, prepare, run, wait, check status. Afterwards, do whatever needs d...

Is it still called 'AfterJob'? That may be contributing to the confusion.

What is the value of the Transaction Size in your OCI stage? Not the box on the 'front' but the tab on the 'back' of the stage.

troywinston wrote:what I mean is to partition the data into 5 chunks. Or parse into 5. How woudl I implement this with the 5 different outputs?

One input link into the Transformer, five output links. MOD on the @INROWNUM so that each output link gets 1/5th of the data, round robin.

What Vince said.

Pretty much what it says - a NULL value in the key field.

UtilityRunJob.

Sure... the Sequencer can prompt for the parameter value and then pass it to any job it runs that needs it.

Exactly. While that may be the 'primary' function, there are many secondary functions it supports and these can include multiple key fields.

Well... it's an option. Did you look under... 'Options'?

Specifically, 'Tools / Edit Version Options'. And no, there is no official way to completely delete a component. It exists to track changes, so it records the fact that you added it and it records the fact that you deleted it.