Shell Programming and Scripting

Hi,

The following shell script returning null results could you please tell me whats the problem in script,

*********************************
#!/bin/ksh
. $HOME/conf/systemProperties/EnvSetup.properties
a=`date +"%y%m%d"`
set -x
for i in `cat /ednpdtu7/u01/pipe/Outgoing/TNS/Configuration/test.txt`
do
echo $i
report=`sqlplus -silent siebel/da!!a5s@ednamip.world <<END
set pagesize 0 feedback off verify off heading off echo on
select meter.x_electronic_id from
siebel.s_asset meter,
siebel.s_asset cm,
siebel.s_asset_rel armcm
where
armcm.par_asset_id = cm.row_id and
armcm.asset_id = meter.row_id and
armcm.relation_type_cd = 'COMMUNICATION-METER' and
armcm.x_rel_status = 'Active'
and cm.serial_num = ('$i');
exit;
END`
echo $report
done
********************************

Does "echo $i" in the 'for loop' show the value of i before the sql is executed? Does the sql itself also returns any value if run outside of the script?

Try with set spool on as by default it will be off.

Cheers gehlnar