DSXchange

Again, that depends on the job design. Stages such as Sort and Aggregator (Hash mode) can block execution of downstream stages. In an unblocked design stages close as close to simultaneously as whatever is controlling the processes can manage.

svSecondAlpha Right(Convert("0123456789","",InLink.TheString),2) svSecondAlphaPos Index(InLink.TheString, svSecondAlpha, 1) svFirstPiece InLink.TheString[1,svSeconAlphaPos - 1] svSecondPiece InLink.TheString[svSecondAlphaPos, Len(InLink.TheString) - Len(svFirstPiece)]

Perhaps an IsValid test for data type "sfloat" (Float) on that dfloat (Double) column in a Transformer stage?

Use a Terminator activity downstream of your Exception Handler activity and enable the compilation option "automatically handle activities that fail".

Almost anything that mentions code point is related to using an NLS map in which a character in the data does not exist.

Transformer stage to divide each record into two, each beginning with two letters, onto two output links. Funnel stage to reinstate a single stream. Column Import stage to parse the numeric characters into separate fields. (Or that could have been done in the Transformer stage.) Pivot stage to produ...

Try sorting the data on the grouping keys and using "Sort" as the aggregation method.

srinivas.g wrote:I have 100 jobs in my categeory and cannot check the individual job that is the reason i asked command.

Pelase suggest?

I did.

Open command executes when the stage opens. Unless there's some designed-in reason not to, every stage opens when the job opens.

The error messages says that you're writing into an int8 somewhere. Show us the full error message, including the name of the stage that's generating it.

The first argument of DSExecute() is the shell in which the command is to execute. It might be "SH" (on UNIX), "DOS" (on Windows) or "UV" (for the UniVerse shell).

That is not a COBOL file definition.

COBOL file definition files tend to have ".CFD" for a name suffix.

Are you seeking an expression that will validate that this value is a valid date? What is the data type of TransDate? Date data type does not have a format - it's stored/processed in a binary format. Then you need to break up the date (or string?) into components and treat each separately. Use stage...

Presumably your anti-virus software has interfered in some way with one of the DataStage client DLLs. Re-installing the DataStage client should be a quick fix.

Probably your COBOL FD has the level 01 item (A margin) other than in column #8 (the default). You have to tell the importer in which column the level 01 item appears.