While using update in Oracle EE (Upsert Mode)
(based on a Non-Key Value.)
Only updating the first occurance.
Any recommendations to avoid this situation?
-K
Oracle EE Update issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm forced to assume that "Orchastrate" misspelled is a result of your not using copy/paste. Get your Oracle DBA to intercept the command to see exactly what statement was executed.
If all else fails, join your data stream to the target table to make sure you get all the relevant rows updated; you may need to stage the results in a persistent Data Set prior to loading, to avoid locking issues.
If all else fails, join your data stream to the target table to make sure you get all the relevant rows updated; you may need to stage the results in a persistent Data Set prior to loading, to avoid locking issues.
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.