#!/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
