#! /bin/sh
CDBS_TOP=${CDBS_TOP:-/data/cdbs1/tools/}
export CDBS_TOP

. ${CDBS_TOP}/util/defines.sh
export CDBS_SERVER CDBS_DB

echo "starting cdbs_sql_gen"
echo "database " ${CDBS_DB?"CDBS_ERROR: CDBS_DB is undefined"}
echo "server " ${CDBS_SERVER?"CDBS_ERROR: CDBS_SERVER is undefined"}
echo "cdbs_top = " ${CDBS_TOP}
date

dir=`pwd`
cd $CDBS_TOP/src/cdbs_sql_gen
# Determine the latest opus delivery number for the next delivery (increments the last value)
delivery_number=`delivery_number.s | awk -f awk.dn`
echo "delivery_number = $delivery_number"
$CDBS_TOP/bin/lock_cdbs $delivery_number
if test $? -ne 0
then
 exit 1
fi
cd $dir
echo "load file(s)" *.lod
$CDBS_TOP/src/cdbs_sql_gen/cdbs_sql_gen *.lod
if test $? -ne 0
then
 $CDBS_TOP/bin/unlock_cdbs 
 exit 1
fi