I am currently unable to find out as to where I am going wrong.
MY script does all the desired work but unfortunately prints multiple copies Instead of one copy.
This is my script:
I have a file which contains the number to be passed:
Suppose my File is named as ACODE.
The contents are numbers like:
now my script is :
Please do not worry about the trace functions or the variables as they are all fine but the problem is that it prints multiple copies . Looks like it is going in a loop somewhere and I can't figure out properly.
In a shell script, the sqlplus section needs to be "fed" commands
using the following syntax...
sqlplus -s $CONNECTID << EOF
set heading off
set feedback off
set pagesize 1000
set linesize 1000
set echo off
set verify off
from emp_details b, external_id_employees a
and b.dept in ('J01','X01','X02','X03','X09','X04','X05','X06','X45')
and acode in
(select acode from employees where acode = $invoice
and ps=0 and fs=2 )
and language_code not in (99)
order by a.external_id;
...Note the "<< EOF" tag which will feed sqlplus everthing that
follows until the next "EOF" tag is reached.
sqlplus -s $CONNECTID <
...will simply redirect the standard input to, in this case,
nothing which is not what you are looking to do. Also, one
other thing I'm assuming is that the SQL works from the
sqlplus command line.
First, read this to understand why you're have difficulty with angle brackets. And a hint to everyone, I clicked on "quote" for his original post to see his original input. That way I could that his here-document was correct.
rooh, I would have sworn that I knew everything about ksh. But I have never seen your "for" statement syntax before. I tested it and it works. I looked in The New Kornshell Command and Programming Language by Morris Bolsky and David Korn. It's not there. They only show
for i in $list
and they never mention
for i in $list
Where did you get this syntax??
You really posted a fragment of a script so it's hard to do anything but visually inspect. But here is something that looks like a double loop waiting to happen:
I'm new to utilities like socat and netcat and I'm not clear if they will do what I need.
I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes.
I'm using Cygwin bash on Windows 10.
My... (3 Replies)
I am facing a weird issue while executing a code below -
sh UKBA_publish.sh UKBA 28082015 3
echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below.
echo "The script is called"... (2 Replies)
I am using blow script :--
FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not
# echo "process found"
echo "process not found"
exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
print"**Changes to the table... (0 Replies)