DSXchange

... only if that's your requirement. If all they have to be is finished (whether with or without warnings, successfully or otherwise) use an unconditional trigger.

Place a Sequencer into the sequence. Job3 and Job4 both feed into the Sequencer, and its output feeds into Job5. Set the Sequencer mode to "All" (all inputs must have fired before its output triggers).

You can not call before/after subroutines directly from seqences. You need to re-create this routine as a transform function if you want to call it via a Routine activity. Or you could build a transform function that is an interlude to the before/after subroutine.

Looks like you've failed to specify a drive letter in the pathname for the package deployment folder (directory) property.

I'm sure it will help someone in the future. Thank you for posting it.

The table will need a key if it's a partitioned table, but does not need a key otherwise.

Check the timestamp format picture used in each job.

A combination of TrimF() and PadString() functions would seem to me to be the way to go.

You've been using DataStage for quite a while now (based on your DSXchange profile) and really should be acquiring these skills. FUNCTION RSunny(aTheString) vLenString = Len(aTheString) Ans = "" For vChPos = 1 To vLenString Ans := Seq(aTheString[vChPos,1]) Next vChPos RETURN(Ans) If you ha...

What do you see when you execute the shrdump command? This executable is to be found in the DataStage engine's bin folder.

Don't allow spaces in a PIC 9 field? That is, make sure that they send you clean data, or declare the field to have an X picture and transform within your DataStage job.

You appear to have a line with only an empty string on it. An empty string is an rvalue - it can not appear on the left-hand side of an assignment statement. Have a look at the generated Job Control code and see where that is, and do something - anything - with the activity that generated that part ...

You should get the same result. So that's good. The difference is which one is tried first. Always select the one that is most likely to occur, because this means that there will be fewer "retries" and better "performance". Thus, if you have a priori knowledge that most of the ro...

What does error code -1722 mean?

Learn to look up Oracle error codes, maybe by using the oerr command. This will aid your diagnosis.

Sequential File stage.

Sequential File stage.

(You can read them, under certain circumstances, using an ODBC driver for text files, but this is not usually the better way.)