DSXchange

I don't see any burning need to make the top level Sequence job do all the work. If each 'sub' Sequence does its own email notification, then they can automatically include exception information in the email via a check-box. The top level Sequence can know that there was an error and handle things a...

Have you done anything to configure DataStage for the OCI stages? Read the DataStage Plug-In Installation and Configuration Guide pdf for the details. You need an Oracle client installed and configured to stand any chance of them working...

Not sure that's possible... probably best to ask Support that question. And then let us know what you find out!

Cool... nanoseconds.

Allegedly, the job runs fine 'by itself' but only has this problem when run by the Sequence... so don't think that's it.

Guess not!

Well... when you have a parameter defined in a Sequence job, and you want to pass it on to another job via a Job Activity stage, you don't use hashes / pound signs around the parameter name. And don't type them in by hand, use the External Parameter Helper goodie (use the 'Insert Parameter Value but...

That is the 'phantom' directory. Cat out the contents of any of the files, that should help answer your question.

However is there any simple way to abort the main sequencer if any of the jobs inside it fails, so that I can right a simple peace of code in my control job and send the notification? Sure... upgrade. Major changes to Sequence functionality in 7.5.x which you will find very helpful in this endeavor...

What 7.x version? That will change the answers... but typically:

Exception Handler -> Notification Activity -> Routine Activity (UtilityAbortToLog)

Two or three hours, I would think... hard to say, too many variables. You could always tail the install log to follow the progress.

I'll skip the whole 'urgent' speech, Ray has one all set to go and I'm sure he'll be along eventually. I just happened to be in the neighborhood...

You've already posted this rather confusing question over in the TX forum, which is the correct place for it... this forum isn't.

I'd suggest you go back there and answer the questions being put to you so you stand some chance of getting a proper answer.

Excellent. :D

First Fatal error coming is : PS_PP_JRNL_LN..PS_JRNL_LN_ERR.IDENT6: At row 4401, link "Insert_Into_MB_JRNL_LN_ERR" Row rejected. [IBM][CLI Driver][DB2] SQL0204N "FDM1PA.PS_MB_JRNL_LN_ERR" is an undefined name. SQLSTATE=42704 Assuming this isn't some odd artifact of the IPC stage, you'll need to cor...

Copy the routine and change the line that comes after the 'Table is not in the cache' comment... From: Open HashTable To: OpenPath HashTable That's it. And to use it, rather than send in just the name of the hashed 'table', send in the complete path. But that should be pretty obvious.