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
********************************