Re: freebcp transaction isolation level when 'bcp out'

Ed Avis <[email protected]> Fri, 8 May 2015 09:40:39 +0000 (UTC)

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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 <[email protected]>