[freetds] freebcp -h TABLOCK syntax
Konrad J Hambrick
konrad at jax01.payplus.com
Sat May 13 07:31:51 EDT 2006
Oops ...
Wrong message for the TABLOCK hint.
I have tried several hints ;-)
This was the message:
Msg 20076, Level 7
bcp_init must be called before any other bcp routines
db-lib: Unable to set hint "TABLOCK"
bcp reports error 1
Same idea ...
Thanks again
-- kjh (sorry about replying to my own post)
Konrad J Hambrick wrote:
> 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
>
More information about the FreeTDS
mailing list