Re: SqlLoader Return Code
From: Mike Krolewski <mkrolewski_at_rii.com>
Date: Mon, 29 Jan 2001 18:40:01 GMT
Message-ID: <954ddv$7ka$1_at_nnrp1.deja.com>
Date: Mon, 29 Jan 2001 18:40:01 GMT
Message-ID: <954ddv$7ka$1_at_nnrp1.deja.com>
In article <953vn7$3t9m$1_at_stargate1.inet.it>,
"Alessandro Galli" <us.progetto.cmlt_at_sanpaoloimi.com> wrote:
>
> Hi
> This is my first time with SqlLoader.
> Do you know if SqlLoader returns a code from its execution, so I can
> test it in my shell code ?
>
> Thank You
> Alessandro Galli
>
>
Yes. However, it is not the best test. SQLLoader generates a log file with information on the processing, including the number of records read and loaded. Since SQLLoader is by default designed to reject some records ( default is 50?), it is possible for the program to run to completion, yet not load all the records.
Check out the manual -- there are good case studies.
-- [Quoted] Michael Krolewski Rosetta Inpharmatics mkrolewski_at_rii.com Usual disclaimers Sent via Deja.com http://www.deja.com/Received on Mon Jan 29 2001 - 19:40:01 CET