log file when the script fails ! - Shell Programming and Scripting

ali560045 · #4 (**permalink**) 01-06-2009

i have now modified the code instead of select i m now doing update . i have use the spool concept here.

But still i m not getting any info like "0 rows Updated" in the spool file. How to get that info in spool file

below the code using update

Code:

#!/bin/ksh

. $HOME/conf/systemProperties/EnvSetup.properties


sqlplus -silent amit/qwerty@edna.world <<END
set pagesize 0 feedback off verify off heading off

spool Script_Fails.log 

UPDATE SIEBEL.S_ASSET_XM SDPX 
SET SDPX.ATTRIB_03   = 'Inactive', 
SDPX.LAST_UPD_BY = '1-42V', 
SDPX.LAST_UPD    = SYSDATE, 
SDPX.ATTRIB_04   = 'SQQ3' 
 WHERE SDPX.PAR_ROW_ID  IN ('090845086LG')
   AND SDPX.ATTRIB_01   = 'AMR Ready' 
   AND SDPX.ATTRIB_03   = 'Active';

commit;
exit;
END

when RUN this update statement in my database it is showing "no rows Update". This same information i want in the spool file.How to get that ?

Thanks in advance