variable=`db2 -x "select col1 from table1`
variable1=`db2 -x "select col1 from table1"` variable=`echo "$variable1" | awk '{print $1}' `