如何在bcp导入数据之前自动清空目的表中的数据？

[amio]

如题。
我要编写一个自动shell脚本，执行bcp导入数据之前自动将表中的数据删除。

[sybasebbs]

前面加个SQL吧,truncate table ****
好象没有什么别的办法吧

[amio]

解决了，我编写了一个shell脚本，内容如下：
#!/bin/sh
#The first arg is the username to operate the database.
#The second arg is the password of the username.
#The third arg is the database name;
#The forth arg is the bcp direction(in or out).

if [ $# -ne 4 ]
then
printf "Usage: bcpsh username password dbname direction([in/out]))\n\n"
exit 1
else
un=$1
pwd=$2
dbname=$3
dt=$4
fi
if [ $dt = "in" ]
then
f=deleteScript.sql
printf "------------------------------------------------"
printf "\nDeleting the old data ...\n" "$f"
while read tname
do
printf "DELETE FROM $tname \ngo\n" >> $f
done < tList.cfg

isql -U$un -P$pwd -D$dbname < $f
rm $f
fi

while read tname
do
printf "\n\n------------------------------------------------"
printf "\nbcp %s %s ...\n" "$dt" "$tname"
bcp $dbname..$tname $dt ./dataFiles/$tname -U$un -P$pwd -c
done < tList.cfg

[dennis2001]

同意ehxz的办法。