DSXchange

No, you're not doing anything wrong. I forgot that the Notification Activity stage breaks the rules of user control and essentially hard-codes an 'Unconditional' trigger to any downstream stage. So those new sequence options would control the outcome. I don't ever link things like that to a Notifica...

Typically, you would just repromote the previous version.

Somehow, I would have expected you to say Rattus!

ray.wurlod wrote:But the subtopic tells us it's a mainframe job.

Doh! Hard to find the cheese at the end of this maze...

Ah... the Astounding Ray! :D

Wasn't there a 'Sorcerer' in there somewhere, too?

Do I recall that you don't actually have the DataStage software? That's going to make your quest a little... difficult.

Check the archives here for the Newsletters the site puts out periodically, one has an excellent overview of hashed files written by our fan favorite poster Ken Bland.

The job has to Abort to initiate the rollback.

You can use the Sequential File stage for this. Are there different record 'types' driven by these first three fields? Define the record as one long string. Parse out the first three fields and then decide where to go from there. Or do you just not know how many fields there will be but you do know ...

Both posts.

sagarkulkarni_in wrote:I need to update and insert using a user defined sql in ODBC stage.

No you don't.

What's wrong with the two link approach that you already know works?

Connection failures would typically result in a simple abort of the job... don't recall any situations where it would result in a 'hang'.

But then I've never heard of HiPortfolio or if there is anything 'special' about it...

You'll notice the post is marked as a TX question... those really need to go in the proper forum to get any attention from the TX folks that hang out here.

Is it something i've not installed? or not parametered correctly? Could be both. You'll need an Oracle client installed on the same server that DataStage is installed on for it to leverage. And then you'll need to configure DataStage so it knows where to find it. It's all documented in both the OCI...

You can also find that information in the hashed files that make a project a Version Control project. Check out:

APM.BATCH
APM.BATCH.MEMBERS
APM.VERSION
APM.VERSION.XREF