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
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Code: Select all
If Qty = 0 Then 0 Else TotalPrice / Qty
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: