DSXchange

The code in BASIC is already in your Repository; there are two "test" routines for sending mail. You can adapt one of those.

No particular precautions, though you do have to grid-enable your jobs (more environment variables) and include an extra Execute Command activity in job sequences.

senthilmp wrote:Yes, am sure that i re compiled the sequence..

Even if you set the Job activities to "Validate" as the run mode the sequence will compile. Please answer Arnd's actual question.

Unfortunately the Operator role can only run released jobs. This is an old technique which few, if any, sites use any more. When you get to version 8 there is a new role (Super Operator) that can run all jobs.

This is a vertical pivot. Search for "vertical pivot" - it has been discussed many times.

It's a vertical pivot. Since you have no other way of doing it, there's no danger of degrading performance because you don't have any "performance".

Search for "vertical pivot".

I am certain that this exact question has been answered recently. How about you Search for it?

1) No. Surrogate keys are solely about uniqueness. There is no need for them to form a sequence. In a parallel environment keys will be being generated on all nodes. 2) You'd create jobs to create and initialize the state file, the latter obtaining the initializing value from a query against the tar...

No other way.

The domain name is the same as the domain name you give when connecting DataStage clients (the topmost field), but you don't need the 9080 port number when using dsjob command.

It's a bug in View Data and I don't believe there's a patch for it. It is fixed in versions 8.0.1 and 8.1. And probably in 7.5.3 as well.

Why have you suddenly introduced unhandled pattern overrides into the story? When do you want the overrides to occur - as input records are being processed or after standardization has occurred? I would guess that T+ is not unhandled in your case.

Is this version 8.0.1 ? I believe that's a known issue in 8.0.1.

Do your #include declarations include full pathnames? If not, are the include files findable?

Don't ever change uvconfig without understanding why. You can break DataStage if you're not careful.

Involve your support provider to supply explanations.