Skip to Content.
Sympa Menu

freetds - Re: [freetds] freebcp out from MS SQL Server drops spaces [NC]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freebcp out from MS SQL Server drops spaces [NC]
  • Date: Thu, 9 Jul 2009 17:08:33 -0400

Cedric ROUVRAIS wrote:
> > Since freebcp supports the -b batchsize option, should the
> > rows_written be compared to the const 1000 or to pdata->batchsize ?
>
> Sybase BCP does not take into consideration the batch size for printing
> to stdout progress. In other words no matter what value you put for the
> -b option, it will always send to stdout every 1000 rows the message
> "x000 rows successfully bulk-copied to host-file.".

I have always found that to be a misfeature. You extract a 1,000,000 rows
and get 1,000 lines of "1000 rows written to host file".

I prefer the symmetry of mating the value of -b to the feedback in both
directions. On uploading, of course, -b controls the commit batch size
(and feedback on standard output). On extraction there's no commit, so
its only effect is to reduce the noise on the terminal.

Thank you for the code. I hope to look at it this weekend unless Frediano
beats me to it.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page