Skip to Content.
Sympa Menu

freetds - [freetds] freebcp -h TABLOCK syntax

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Konrad J Hambrick <konrad AT jax01.payplus.com>
  • To: freetds AT lists.ibiblio.org, Konrad J Hambrick <konrad AT jax01.payplus.com>
  • Subject: [freetds] freebcp -h TABLOCK syntax
  • Date: Sat, 13 May 2006 07:27:56 -0400

All --

I am having trouble invoking freebcp with
the -h TABLOCK hint.

Syntax I tried:

freebcp MyDBName.DBO.MyTableName \
in "/tmp/mytablename.txt" \
-f "/tmp/mytablename.fmt" \
-h "TABLOCK" \
-m 1 \
-t "|" \
-S "$TarHost" \
-U "$TarUser" \
-P "$TarPass" \
-e "/tmp/bcp-load.err"

Message returned:

Msg 20076, Level 7
bcp_init must be called before any other bcp routines
db-lib: Unable to set hint
"order(EmployeeID,EmployeeEarnID,EmployeeEarnSeqNum)"
bcp reports error 1

Am I doing something obviuosly incorrect ?

Thanks !

-- kjh




Archive powered by MHonArc 2.6.24.

Top of Page