Hi
Dont we have orabulk stage in parallel jobs!
Is there any way to capture rejected records by using
write method = sqlloader but not upsert
Thanks
Orabulk in Parallel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, it's called the Oracle Enterprise stage with load method = "Write". This invokes sqlldr "under the covers".
Once sqlldr is started DataStage no longer has control. You can process the log and bad files produced by sqlldr in DataStage once sqlldr finishes, but there is no mechanism to capture rejected records while sqlldr is running, exactly as there isn't when invoking sqlldr by any other mechanism.
Once sqlldr is started DataStage no longer has control. You can process the log and bad files produced by sqlldr in DataStage once sqlldr finishes, but there is no mechanism to capture rejected records while sqlldr is running, exactly as there isn't when invoking sqlldr by any other mechanism.
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.