DSXchange

You will need to define it in all controlling sequences. Meaning from the job back up to the 'main' sequence job, any intermediate level 'sub-sequence' will need that parameter as well. Remember, it will need to be passed down from that first sequence job to the job in question through all of the st...

Exactly. Probably an Oracle (not DS) difference issue, most likely with the NLS_DATE format. Which adding quotes around the parameter name would fix. [cough]

You've got an unmatched double-quote in the DSSendMail call and if you add the 'missing' one at the end, then everything becomes a literal and your job list won't work correctly. Try it in two steps, first build a string from the parts you have and then pass that string to the function: If Len(TRIM(...

Not so elusive, what you need has been posted in this thread more than once: SETFILE and COUNT. Search the forums for SETFILE, its syntax and usage *are* out there. For scripting help, search the forums for dssh which is where the commands would be run outside of the Adminstrator GUI.

Seems like all you'd need to use is the CompletedJob variable, that CHAR(10) is a carriage return and the "JobControl" string is needed for the DSLogInfo function call, not in your email.

Likewise, use FailedJob or WarningJob for those problem children lists.

One 'trick' is to build your delimited list in the Initial Value of a stage variable and leave the Derivation blank (so it is only evaluated once) and then use the Index function to check for your value in that list of values. For example: svValidValues: AAA,BBB,CCC,DDD Or you could even use your jo...

That would be an O/S limitation, not a DataStage one.

License keys are version and O/S specific.

Why a mainframe COBOL program, do you not need to unpack these fields regardless in your job? The job is doing that automatically when the file is read in, as you noted, so I'm honestly curious - why the need to check anything while it's still packed?

Not Mr Kim, but I always end a Sequence job with a Sequencer as that allows the last activity to have an output / exit side trigger that can be checked by the job control and thus make it restartable.

Hope none of the words were too long.

You need quotes around the parameter in the TO_DATE function:

gaurav.bhardwaj wrote:Let me explain my job in detail, which will facilitate proper discussion and help in arriving at a solution.
<snip>

We'd already surmised all that and given you the solution.

As is mine.

Of course - an Exact Match search for CLOB returned 121 matches for me.

Have you tried searching the forums for "CLOB"? The issues with that (unsupported) data type have been discussed here quite a bit.