freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] freebcp transaction isolation level when 'bcp out'

From: Ed Avis <eda AT waniasset.com>
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] freebcp transaction isolation level when 'bcp out'
Date: Fri, 8 May 2015 09:40:39 +0000 (UTC)

The new -O option to freebcp (in 0.95rc1) can be used:

freebcp database..table out file \
-O 'set transaction isolation level read uncommitted' ...

Thanks!

My only qualm is the behaviour of reading from a file if 'a valid filename'.
That sounds like it could too easily go wrong - filenames can contain
spaces, and SQL can consist of a single word. I suggest it would be better
to have two separate options.

--
Ed Avis <eda AT waniasset.com>

Re: [freetds] freebcp transaction isolation level when 'bcp out', Ed Avis, 05/08/2015