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.
How to abort job when a string value is in a decimal field?
Moderators: chulett, rschirm, roy