to find whether update query is successfull or not using Ksh Script

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

i have a script that performes an update operation. I just wanted to know whether that update statement is successfull or not.

Below the script:

Code:

#!/bin/ksh
. $HOME/conf/systemProperties/EnvSetup.properties
sqlplus -silent sie/da@edn.world <<END
set pagesize 0 feedback off verify off heading off trimspool on echo off
spool /ednadtu3/u01/pipe/naveed/class/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 (select B.PAR_ASSET_ID from SIEBEL.s_asset_rel B
                                         where B.relation_type_cd= 'SDP-METER' ---- and X_rel_status= 'Active'
                                             and B.asset_id
                                                IN (select A.asset_num from SIEBEL.s_asset A where
                    A.x_electronic_id IN ( '090845086LG')))
   AND SDPX.ATTRIB_01   = 'AMR Ready'
   AND SDPX.ATTRIB_03   = 'Active';
commit;
spool off
exit;
END

I have use the concept of spool file but in my script the generated spool file "Script_Fails.log" is containg null values .Means a 0 byte spool file is getting created . The query works fine in my database and successfully creating spool file but using the script it's creating a 0 byte spool file.please help me in this

Below the spool file in SQL*Plus:

Quote:

SQL> UPDATE SIEBEL.S_ASSET_XM SDPX
2 SET SDPX.ATTRIB_03 = 'Inactive',
3 SDPX.LAST_UPD_BY = '1-42V',
4 SDPX.LAST_UPD = SYSDATE,
5 SDPX.ATTRIB_04 = 'SQQ3'
6 WHERE SDPX.PAR_ROW_ID IN (select B.PAR_ASSET_ID from SIEBEL.s_asset_rel B
7 where B.relation_type_cd= 'SDP-METER' ---- and X_rel_status= 'Active'
8 and B.asset_id
9 IN (select A.asset_num from SIEBEL.s_asset A where
10 A.x_electronic_id IN ( '090845086LG')))
11 AND SDPX.ATTRIB_01 = 'AMR Ready'
12 AND SDPX.ATTRIB_03 = 'Active';
0 rows updated.
SQL> commit;
Commit complete.
SQL> spool off

cfajohnson · #2 (**permalink**) 01-06-2009

Quote:

Originally Posted by ali560045

i have a script that performes an update operation. I just wanted to know whether that update statement is successfull or not.

Check the return code which is stored in "$?".

ali560045 · #3 (**permalink**) 01-07-2009

Can you just explain me in detail as to where do i need to use that.

cfajohnson · #4 (**permalink**) 01-07-2009

Quote:

Originally Posted by ali560045

Can you just explain me in detail as to where do i need to use that.

Code:

sqlplus ... <<END
...
END
case $? in
     0) echo Success;;
     *) echo Failed ;;
esac

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Script not successfull in cron	sandeep_kmehra	Shell Programming and Scripting	2	09-04-2008 10:33 AM
find -mtime query	Rajat	UNIX for Dummies Questions & Answers	1	07-09-2008 07:12 AM
Dynamic update loop query on Sybase database	Alaeddin	Shell Programming and Scripting	10	12-13-2007 06:26 AM
query about find and -exec	shriashishpatil	UNIX for Advanced & Expert Users	2	04-12-2007 01:16 AM
find -perm query	napolayan	UNIX for Dummies Questions & Answers	1	11-28-2006 02:28 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by