[Fwd: SQL loader query under OEM]

Richard Bragg wrote:
>
> I load in 2 files everyday that are produced automatically.
>
> These files are composite from a number of sources, i.e. a set of
> programmes
> each create their own file, these are merged, ftp's to my database
> machine
> where I load them. The duplicates are not needed so when I set up the
> mechanism on 805 I used the primary key to reject the duplicates.
>
> When the load finishes the data files are compressed just after deleting
> the previous days files.
>
> What I need to do is not have the job marked as failed if the only
> problem are warnings i.e. PK violated. I do want to know if there is a
> real failure
> e.g. data file missing, can't connect, too many duff records.
>
> Also I want to protect the data files in the event of a failure. i.e.
> the systems will send a new file anyway.
>
> Can this be done in OEM/SQL loader or do I need to start playing with
> scripts?
>
> Hints any one?
>
> TIA
Received on Mon Feb 05 2001 - 11:19:49 CET