[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