Abort job when exceeding limit on a Surrogate Key value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rafidwh
Participant
Posts: 179
Joined: Mon Oct 10, 2005 11:30 pm

Abort job when exceeding limit on a Surrogate Key value

Post by rafidwh »

How to terminate a job if the Surrogate Key value reaches the max value be it signed/unsigned 32/64 bit while processing a single dataset.

Thanks !
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

Use a Tranformer and put your condition as link constraint, user the "Abort After Rows" property, set it to 1 and the job will abort when there is even a single row for which you SK is greater than the preset value.
- Zulfi
Post Reply