Trapping errors from SQL*Loader
Posted: Tue Mar 16, 2004 10:37 am
I have a job that loads data from a flat file into oracle.
Datastage generates an SQL*Loader to perform this.
Problem is, the logs in director show that all the records have been processed (and all lights are green) although half the records are invalid and didn't load because of not null constraints.
The SQL*Loader log does show the errors (which is burried deep in working directories) but nowhere in datastage does it hint that not all the record have loaded.
How do I make the job fail / show red lights / scream ??
I've tried to add the environment variable $APT_ORACLE_LOAD_OPTIONS and set to OPTIONS (ERRORS=1) but even that does not make datastage show any errors.
Obviously I do not want to add a transformer and test all the constraints myself...
Datastage generates an SQL*Loader to perform this.
Problem is, the logs in director show that all the records have been processed (and all lights are green) although half the records are invalid and didn't load because of not null constraints.
The SQL*Loader log does show the errors (which is burried deep in working directories) but nowhere in datastage does it hint that not all the record have loaded.
How do I make the job fail / show red lights / scream ??
I've tried to add the environment variable $APT_ORACLE_LOAD_OPTIONS and set to OPTIONS (ERRORS=1) but even that does not make datastage show any errors.
Obviously I do not want to add a transformer and test all the constraints myself...