DSXchange

I've a job which includes a sequential file stage and a transformer stage.
Is there any way to get the routine in the transformer executed, if zero rows are passed from the sequential file stage. I've to write the return value from the routine to a target table.

Thanks in advance
Sumesh

No, don't think it is possible from within the transformer, if the transformer is just following the Sequential file stage. Introduce one more stage in between (may be an IPC) (and try DSGetLinkInfo to get the processed row counts and call the routine to get the value to be written to the target table) and place it to the target table link only if the rows processed count is zero for the sequential file stage.

What does IPC mean?. Can u be more specific?

InterProcess Communication??

You can run an after-stage subroutine in which you can check the rowcount or number of rows present in the sequential file and then pass the return value. Makes sense ???

Yes, but the question is - will it fire if the job processes zero rows? I don't believe so.

However, the answer is a definitely 'yes' if you make it an after job routine.

It will Craig. Just tested it out. After stage routine will fire regardless of the row count.

Good to know... I'm not anywhere that I can actually test anything.