[SQL] Why Update is happening twice? Post: 302537767

Sponsored Content

Top Forums Programming [SQL] Why Update is happening twice? Post 302537767 by rshivarkar on Sunday 10th of July 2011 01:42:51 AM

07-10-2011

Registered User

[SQL] Why Update is happening twice?

Example 1=>
I have unix ksh file and I am calling sql file from it.

(table 1 contains 2 rows -
ID Name
1 test't
2 Pet's
)

below sql statement is part of sql file:

update table1 set name = replace(name,'''','''''') where instr(name,'''') > 0 ;

--I see below statement in my log file
2 rows updated.

2 rows updated.

--after this update I see name is updated to test''''t and pet''''s

(Problem here is I see 2 rows updated two times.even if there is one row its getting updated two times)

--------------
Example 2)
SO I have created other ksh and sql and in that sql I have written same update and its working fine.

update table1 set name = replace(name,'''','''''') where instr(name,'''') > 0 ;

--I see below statement in my log file

2 rows updated.

--after this update I see name is updated to test''t and pet''s

--
Why there are 2 updates in first example?

rshivarkar

View Public Profile for rshivarkar

Find all posts by rshivarkar

8 More Discussions You Might Find Interesting

1. AIX

Ping is happening, telnet is not happening

HI all, Ping is happening to a AIX box...but telnet is not happening... AIX box doesn't have any conslole... Please help how to resolve it. Thanks in advance .. Manu

2. Shell Programming and Scripting

Help shell script to loop through files update ctl file to be sql loaded

I am currently trying to find a way to loop through files in a given directory and for each file modify a ctl file and sql load it. I have been using the sed command to change the infile, badfile parameters of the control file. I have not yet tried to sql load it. Requirement: files are ftp to...

3. UNIX for Dummies Questions & Answers

what's happening with my keyboard

hi everybody. i ussually use unix and windows, but mainly unix-mandriva distribution, and i have a problem. i have like main os unix, and windows as secondary, and this one is loaded by vmware application. well, when a i load vmware to execute windows afterwards when i return to unix, in this...

4. Shell Programming and Scripting

Incrementing a variable is not happening

Hi All, Iam trying to increment a variable Following is the code #!/usr/bin/ksh i=1; i='expr $i+1'; echo $i; Output: expr $i+1 not able to understand why its happening in that way i was expecting result as 2... if the above method is worng .. can you help how i can get...

5. UNIX for Dummies Questions & Answers

how to capture no. of rows updated in update sql in unix db2

hi, i am a new user in unix..and we have unix db2. i want to capture the no. of rows updated by a update db2 sql statement and redirect into a log file. I've seen db2 -m...but not sure how the syntax should be. The update sql that I'm going to run is from a file... Can you please share...

6. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

hi all, i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code. sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE whenever sqlerror exit set serveroutput on size 1000000 declare l_rc ...

7. Fedora

Leap second happening

Have anybody heard about the Leap second problem Leap second :A leap second is a one-second adjustment that is occasionally applied to Coordinated Universal Time (UTC) in order to keep its time of day close to the mean solar time. How could i avoid such thing in my script which i deal with...

8. Shell Programming and Scripting

Function call is not happening

set -x QM=$1 port=$2 KILLQ () { ps -efww | grep $QM | grep -v grep | tr -s " " " " | cut -d" " -f2 |xargs kill -9 sleep 3 echo "Checking the Queue" CHKQ } CRTQ () { strmqm $QM runmqlsr -m $QM -t TCP -p $port & } CHKQ ()

LEARN ABOUT DEBIAN

oarnodesetting

oarnodesetting(1)						   OAR commands 						 oarnodesetting(1)

NAME

       oarnodesetting - Change the state and properties of a node in OAR.

SYNOPSIS

       oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]

DESCRIPTION

       This command is used to Change the state and properties of a node in OAR.

OPTIONS

       -a, --add
	   Add a new resource.

       -s, --state STATE
	   Set the new state of the node. The available states are: Alive, Absent and Dead.

       -m, --maintenance on/off
	   Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).

       -h, --hostname HOSTNAME
	   Set the node hostname.

       -r, --resource
	   Set the resource.

       --sql
	   Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").

       -p, --property "PROPERTY=VALUE"
	   Set the property of the node to the given value.

       -n, --nowait
	   Do not wait for job ends when the node switches to Absent or Dead.

EXAMPLES

       oarnodesetting -s Alive -h node012
       oarnodesetting -s Absent -h node012

COPYRIGHTS

	Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

oarnodesetting							    2012-05-23							 oarnodesetting(1)