How to abort job when a string value is in a decimal field?

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
Lavanya B
Participant
Posts: 20
Joined: Mon Oct 30, 2006 12:32 am

How to abort job when a string value is in a decimal field?

Post by Lavanya B »

Hi,

We are getting a string value 'NULL' in a field Col1 from a sequential file. This field needs to be mapped to a decimal field in Oracle as null value. We are using Oracle connector stage as target.

The job is not aborting when we are running this scenario. Zeroes are getting populated in the target Oracle table.

Are there any settings in the Oracle connector stage to abort the job in this case?

We do not want to use "If then else" logic to set the value to null like if Col1='NULL' then SetNull() else Col1. We want the job to abort.

Please help us on this scenario.
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

Feed it to a transformer.

In the transformer, have two output links. On one of the links, have a constraint send the data down if the column value is NULL. Also set the the link properties to abort after one row.
Post Reply