[freetds] freebcp -h TABLOCK syntax

Konrad J Hambrick konrad at jax01.payplus.com
Sat May 13 07:27:56 EDT 2006


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