Bteq Script

#!/usr/bin/bash

. $HOME/.profile
CURRENT_DATE=`date '+%Y%m%d%H%M%S'`
CURRENT_HOUR=`echo ${CURRENT_DATE:9:2}`
echo $CURRENT_DATE
echo $CURRENT_HOUR

cd /home/user
/usr/bin/bteq << EOF > update_data.${CURRENT_DATE}.log 2>&1
.LOGON dbc/userid,userpwd
call procedure_name(${CURRENT_HOUR});
.logoff

EOF