#!/bin/csh
#
# DB load for OPUS 2010.3
#---------------------------------------------------------------------
set WHICH_SERVER = $1
set WHICH_DB = $2
#
isql -e -S${WHICH_SERVER} -D${WHICH_DB} -Ucmosogs <<EOF
delete from cgg1_keyword
delete from cgg4_order
go
EOF
#
echo "loading cgg1_keyword..."
bcp ${WHICH_DB}.dbo.cgg1_keyword in cgg1_keyword.dat -f cgg1_keyword.fmt -b 1000 -S${WHICH_SERVER} -Ucmosogs
#
echo "loading cgg4_order..."
bcp ${WHICH_DB}.dbo.cgg4_order in cgg4_order.cdf -c -t',' -S${WHICH_SERVER} -Ucmosogs
#
echo "Done."
