DSXchange

You don't need Field() at all. Once Index() has reported the location of the start of "ASIA EUROPE" extract an 11-character substring beginning at that position, provided that that position is not zero. Otherwise return "".

Yet another method is to use a Filter command using (for example) a cat command.

You will need to use Microsoft facilities. There is no mechanism in DataStage for this task.

Leave out not_nullable from the field definitions. Leave out nullable from the record declaration. Both are incorrect. Field are not nullable unless marked nullable. Records can not be nullable.

Probably not. I'm talking about eliminating the need for restartability within jobs.

If by DRS you mean Dynamic RDBMS stage type, then the answer is yes, it has existed since the early version 7s.

Welcome aboard.

Have you tried right-clicking on the stage and de-selecting Grid Style?

Not really. You can query the local database, but that's not an operating system command. From the operating system you need something like the following. DSHOME=`cat /.dshome` export DSHOME . $DSHOME/dsenv $DSHOME/bin/dssh "SELECT CATEGORY FMT '50L' FROM DS_JOBS WHERE NAME = '<<Job name>>';&qu...

Put the cp into the Command field and everything else into the Parameters field. Job parameters can not be resolved in the Command field.

What is an ORS Connector?

Put a Routine activity into the master sequence to read the user status area of the "JCL" job.

Full information about the parts of a Configuration file are to be had in the Parallel Job Developer's Guide

Welcome aboard. Many approaches are available. First question is how accessible the previous snapshot is. It's probable that Oracle has a comparison tool (I don't know). If you want to do it within DataStage, probably the best approach is to use one of the change detection stage types, namely Differ...

Care to share how you resolved it?

The idea is not to have them sign the document, but to think again about the implications of the decision they want to make.