Thread: COPY COMMAND

COPY COMMAND

From

Deepa K

Date:

07 October 2003, 06:22:43

Hi All,
Is it possible to insert n rows with 1 or 2 invalid rows
using copy command. I used it, it rollbacks everything even if 1 row
gets an error. Is their any other way to do it.

TIA

-- 
regards,
Deepa K.

Re: COPY COMMAND

From

Richard Huxton

Date:

07 October 2003, 07:57:34

On Tuesday 07 October 2003 07:29, Deepa K wrote:
> Hi All,
>         Is it possible to insert n rows with 1 or 2 invalid rows
> using copy command. I used it, it rollbacks everything even if 1 row
> gets an error. Is their any other way to do it.

You need to remove the bad rows. This is IMHO a "Good Thing" (TM) although it
can be irritating.

You should get a line number to indicate where the problem rows are.

--
  Richard Huxton
  Archonet Ltd