Need help in script

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Need help in script
# 1  
Old 01-11-2017
Need help in script

I am trying to write shell script that will pull output from sql db and store it in file in UNIX.
script:-
Code:
#echo $conn
sqlplus -l $conn << EOF
select name from employee where id = $1;
/
exit
EOF

i want to run the script in a way that i will pass id as parameter as well as output shoudl be stored in a file whic will also be passed as parameter.
Like below
if i want name of employee with id = 1 and want to store the output in out.txt, i want to run it like below:-

Code:
ksh script 1 out.txt

.


how can i achecive that

Last edited by RudiC; 01-11-2017 at 07:19 AM..
# 2  
Old 01-11-2017
Where are you stuck? You could tell sqlplus to spool to $2, or redirect the entire script's output like
Code:
ksh script 1 > out.txt

# 3  
Old 01-11-2017
the thing is when i do like you said it gives output like
Code:
name
--------
ajay


i want the output file to have only ajay

Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 01-11-2017 at 07:30 AM.. Reason: Added CODE tags.
# 4  
Old 01-11-2017
Can't you switch the headers off?
# 5  
Old 01-11-2017
You need to add a statement to your SQL to turn off the column headings:-
Code:
SET HEADING OFF

You can also call sqlplus with a -s or -S flag to reduce the information displayed during the connection.



I hope that this helps,
Robin
# 6  
Old 01-11-2017
thanks,
it is generating the desired result in file.
Though there is one issue.
output shown in file is like:
Code:
more out.txt

ajay


there are blank spaces which should not be there

---------- Post updated at 08:15 AM ---------- Previous update was at 07:25 AM ----------

target acheived.

thanks for help
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

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)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

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. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

5. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys 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. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question