FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Hi,

you can use the -m flag to freebcp to specify a maximum number of errors
allowable before it gives up
the -e flag allows you to specify an errors file in which the errors are
listed.

HTH,

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
dnoble71 AT juno.com
Sent: 30 June 2007 04:22
To: freetds AT lists.ibiblio.org
Subject: [freetds] freebcp failing to continue loading records
afterduplicate encountere d


I am new to Linux and freetds.

We are working with Sybase 12.5.3 on an HP 9000 Server.

On a Linux box using freetds 0.64, we run the freebcp command to load
records into a Sybase table and as soon as it encounters a duplicate
key in the table freebcp stops loading records.

I have seen freebcp continue to load records after it encounters a
duplicate key error on another system. Is there a configuration setting
in freebcp or Sybase that I need to set to allow for the loading of
records to continue?

thanks in advance for your help
Doug 

_____________________________________________________________
Click to find great rates on medical insurance, save big, shop here
http://track.juno.com/s/lc?u=http://tagline.untd.us/fc/Ioyw6iifSXvkZ8ehf
huS0KKDEB83TWeZvNjOfDdvt1UQfT7wWBSpXT/


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

This message w/attachments (message) may be privileged, confidential or 
proprietary, and if you are not an intended recipient, please notify the 
sender, do not use or share it and delete it. Unless specifically indicated, 
this message is not an offer to sell or a solicitation of any investment 
products or other financial product or service, an official confirmation of 
any transaction, or an official statement of Merrill Lynch. Subject to 
applicable law, Merrill Lynch may monitor, review and retain e-communications 
(EC) traveling through its networks/systems. The laws of the country of each 
sender/recipient may impact the handling of EC, and EC may be archived, 
supervised and produced in countries other than the country in which you are 
located. This message cannot be guaranteed to be secure or error-free. This 
message is subject to terms available at the following link: 
http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch 
you consent to the foregoing.
--------------------------------------------------------