DSXchange

I want to make job aborted when there is no records to update in the target table, can anyone tell me how can we achieve this?

Why abort? Why not prevent the job from running in the first place?

Either way is possible. Run a command that checks the existence of the files and sets its exit status how you wish. Then test that.

If you're using a before-job subroutine, set ErrorCode to a non-zero value to abort the job.

Clarify what you mean by "no records to update in the target table". Ray went with "no records in the source" but I'm wondering if you mean you send an update to the target and it updates zero records?

One more way i can think of is, get the Link count using DSGetJobInfo() and abort if it's 0.

Thanks to everyone for all your replies.

Ray: I could not know whether there are records in the target table to update. because i get the rows from source table and update to target table. I know while updating only.

Craig: Yes craig, If there are no matching records in the target table. we get rows in the source.

Pandeesh: I believe we can use that function in Transformer only.

So,first of all find out whether there are any matching records are there or not using Lookup or join,After that based on the count decide needs to abort or to update.

prasad v wrote:Yes craig, If there are no matching records in the target table. we get rows in the source.

That's one of the things the lookup stage is for.

that works !! but I want to make the job abort when it fails to update atleast one record.

I'm not going to have the exactly correct terminology but (from what I recall) you can set the Lookup to Fail if a match is not found...