Skip to Content.
Sympa Menu

freetds - Re: [freetds] freebcp failing to continue loading records afterduplicate encountere d

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freebcp failing to continue loading records afterduplicate encountere d
  • Date: Mon, 2 Jul 2007 11:24:21 +0100

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.
--------------------------------------------------------




Archive powered by MHonArc 2.6.24.

Top of Page