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

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

oarhold

oarhold(1)							   OAR commands 							oarhold(1)

NAME

       oarhold - hold a job in OAR batch scheduler.

SYNOPSIS

       oarhold [--array][job_ids][--sql "sql syntax"][-r][-h][-V]

DESCRIPTION

       Ask OAR to not schedule jobs until oarresume command will be executed.

OPTIONS

       -r, --running
	   Manage not only Waiting jobs but also Running one (can suspend the job)

       --array
	   Hold array job(s) passed as parameter (all the sub-jobs of the given array job(s))

       --sql
	   Hold jobs which repond to the SQL where clause on the table jobs (ex: "project = 'p1'")

       -V, --version
	   Print OAR version number.

       -h, --help
	   Print help command message.

	   oarsub(1), oardel(1) oarstat(1), oarnodes(1), oarresume(1)

COPYRIGHTS

	Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

oarhold 							    2012-05-23								oarhold(1)