correct panyam, i too thought so. When i execute it in the command line. i am getting the value. But when i put it in the script, the value is not getting assigned to the variable.
The code in the scripts is
PREVIOUS_QTR=`db2 -x "SELECT statement"`
PREVIOUS_QTRAPPLBTY= `echo "$PREVIOUS_QTR" | awk '{print $1}'`
echo $PREVIOUS_QTRAPPLBTY

in the verbose mode, i got this

PREVIOUS_QTR= 200901

PREVIOUS_QTRAPPLBTY= `echo "$PREVIOUS_QTR" | awk '{print $1}'`
+ awk {print $1}
+ echo 200901
+ 200901
+ PREVIOUS_QTRAPPLBTY=
genTmGapQTR.ksh[22]: 200901: not found.
echo $PREVIOUS_QTRAPPLBTY
+ echo


Please help me.. in this