Skip to Content.
Sympa Menu

freetds - RE: [freetds] Freebcp 2GB file limit

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Freebcp 2GB file limit
  • Date: Thu, 28 Oct 2004 15:50:06 +0200

On Thu, 2004-10-28 at 15:35, Thompson, Bill D (London) wrote:
> Tom,
>
> That's not a freebcp message , as far as I know.
> There is a file size limit on your operating system, probably.
> I have run into the same problem with Sybase "bcp" in Solaris.

Actually it's a bit of both. I think you need to use special calls or
flags to handle >2GB files.

Checking the open(2) man page on linux I see the O_LARGEFILE flag, for
example.

Michael


> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Thomas A. Lowery
> Sent: 28 October 2004 14:29
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Freebcp 2GB file limit
>
>
> When using freebcp to extract a large table, I'm receiving a
> "exceeds file size limit". It looks like a 2GB boundary.
> I've worked around the problem by using a named pipe, but I wonder
> if there a build configure parameter to handle >2GB?
>
> freebcp version $Id: freebcp.c,v 1.17 2003/01/26 10:27:35 freddy77 Exp $
>
> Tom
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> --------------------------------------------------------
>
> If you are not an intended recipient of this e-mail, please notify the
> sender, delete it and do not read, act upon, print, disclose, copy, retain
> or redistribute it. Click here for important additional terms relating to
> this e-mail. http://www.ml.com/email_terms/
> --------------------------------------------------------
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html




Archive powered by MHonArc 2.6.24.

Top of Page