DSXchange

Hi all,

In one of my job I got this warning message

analyzeAndPrepare:divisor is 0.

I suppressed the warning and ran the job

The next job which is a load job is failing with
Unable to insert a record into the table due to ORA-01722: invalid number


Is this error because of the divison by 0 warning

What values Datastage assigns when Divison by zero happens

Division by zero is undefined. Therefore it does not make sense to ask what value gets assigned. DataStage (correctly) throws an exception. It's up to you to check the divisior if there's any chance of it being zero.

Thanks Ray

I will certainly handle that division by zero

My question is will it assign a non numeric character

I want to know if this column is the issue or
there is another column that causing the issue of inserting non numeric to a numeric column

Regards

More than likely that is the issue. Fix the division error and you'll see.

You can generate any value that's legal for the data type of the target column.