DSXchange

As the final stage will be a passive stage (loader), you cannot order your input link there. So only the output link from the prev (trans) stage can be controlled in this case.

If it is just one row, you can do it via any standard editor.

Note that the dsjob command will also return the status code.

If there are only 5 rows, you can generate a trans stage to provide 500 rows and obtain the values.

Make sure that no-one is logged into the proj when you do that.

Did you monitor the memory or disk usage when this agg stage was running.

What is the derivation in the agg stage?

You can run them as foreground process. They will not wait until you request it.

There must not be any quotes around the command.

You can control this from the transformer which sends the rows by ordering the links.

I agree with Ray on the Feb date matter. You can perform OConv(IConv(dt)) to obtain the correct date in that case. But the requirement from the initial user is not yet clear as he has stated that he wants to find 'difference' between two dates. I have to compare the output with another date of same ...

Maybe if you want to retain the max value, then your logic must be changed to If RowProcCompareWithPreviousValue ( L_LectODS_SUIVI_ETAT_LOCATIF.ID_GROUPE_LOT) Then RowProcGetPreviousValue( L_LectODS_SUIVI_ETAT_LOCATIF.ID_DATE_DEBUT_VALIDITE)-1 Else L_LectODS_SUIVI_ETAT_LOCATIF.ID_DAT...

Maybe you can look for 'SELECT' or 'FROM' in your export file.

If you run with -run option alone, they will run without waiting for finish.

It will be beneficial if you have more than one processor in your system.

Simplest way may be to split the year separately and concat it back after the computation.