error in insert statement

Shell Programming and Scripting
1

hi,

When i try to run the code below, i get the following error

"ksh: syntax error: `(' unexpected"

i am not able to figure it out. Can anyone help me?

Code:

2

try this

ERROR_CD=$1
PARAM_PASSED=$#
CUR_YEAR=`date | awk '{print$6}'`
CUR_MONTH=`date +%m`
CUR_DAY=`date +%d`
CUR_TIME=`date | awk '{print$4}' | sed -e 's/:/./g'`
TODAY_DATE=`echo $CUR_YEAR-$CUR_MONTH-$CUR_DAY-$CUR_TIME.00`
if [ $PARAM_PASSED = 1 ]; then
if [ $ERROR_CD = 01 ]; then
db2 connect to databasename user <username> using <password>
db2 "insert into <tablename> (col1,col2,col3,col4,col5,col6) values('$TODAY_DATE','$ERROR_CD','Val1','Val2','VAl3','Val4');"
terminate
elif [ $ERROR_CD = 02 ]; then
db2 connect to databasename user <username> using <password>
db2 "insert into <tablename> (col1,col2,col3,col4,col5,col6) values('$TODAY_DATE','$ERROR_CD','Val1','Val2','VAl3','Val4');"
terminate
elif [ $ERROR_CD = 03 ]; then
db2 connect to databasename user <username> using <password>
db2 "insert into <tablename> (col1,col2,col3,col4,col5,col6) values('$TODAY_DATE','$ERROR_CD','Val1','Val2','VAl3','Val4');"
terminate
fi
else
exit
fi
3

Thanks.. It worked!!