Hi,
How to capture rejects from Oracle enterprise stage with load option used? I mean, toc apture in to plain text file? Than k you.
Sattibabu
Capture rejects in Oracle Enterprise with load option?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Thu Oct 12, 2006 1:05 pm
-
- Participant
- Posts: 56
- Joined: Mon Oct 16, 2006 7:32 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 6
- Joined: Thu Oct 12, 2006 1:05 pm
In case of Oracle Enterprise stage in PX job, any parameter at server level to setup to tell sqlldr where to write bad files? What is the default log and bad files location? Thank you.ray.wurlod wrote:The Load option is going to use sqlldr, so you will be able to look in the "log" and "bad" files generated by the bulk loader utility. ...
sattibabu
-
- Participant
- Posts: 56
- Joined: Mon Oct 16, 2006 7:32 am
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
DataStage doesn't really know whether the load command worked or failed (in terms of number of rows loaded). You could write a DataStage Routine that opens the log file and parses it for success and failure message for use in log messages and Sequence job triggering.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn