Re: dynamic error value in sql loader
From: Munish Gupta <monu_m_at_spymac.com>
Date: 19 May 2004 21:02:16 -0700
Message-ID: <e51a726f.0405192002.6ffc8f4a_at_posting.google.com>
Date: 19 May 2004 21:02:16 -0700
Message-ID: <e51a726f.0405192002.6ffc8f4a_at_posting.google.com>
is there any way i could do this in a windows batch file?
Steffen Conrad <steffen.conrad_at_gmx.de> wrote in message news:<2h11mqF7s6muU1_at_uni-berlin.de>...
> Munish Gupta wrote:
>
> > 1.) at the command where sql loader is run. But as i am running this
> > command thru a batch file.. i am unable to pass it a dynamic value..
>
> why not count the amount of rows in the batch file and set appropriate
> errorcount in the sqlldr call?
>
> for linux/unix this would simple:
>
> NUM_OF_ROWS = 'wc -l input_file'
> sqlldr ... errors=$NUM_OPF_ROWS ...
>
> Steffen
Received on Thu May 20 2004 - 06:02:16 CEST