Shell Programming and Scripting

hi nua7,

thanks for the interest..

actually i am not getting any error.. when i am trying to execute the command, its creating the output file but not redirecting ...means a zero byte file will be created..

also, i am connectin to sqlplus in between.. and am getting the output of th sql query and am using the grep command to format that file... which i am unable to do..

also, can anyone help me by saying how can i spool a file.. i just know that i need to use spool on and spool off commands to do that.. but then where will i be gettnig the output .lst file..

thanks,
Krips.

hi era,

i tried using a simple shell script as you said where i just gave this much :

#!/bin/sh

grep -v 'row' /path/filename > /path/output_filename


here i am getting the output perfectly...
but in the previous shell script where i encountered the problm, i was connecting to sqlplus as well..
thern i used something like this

echo 'select STATEMENT' > sql.sql
echo 'quit' >> sql.sql

and i am sqlplus that will run this sql.sql for the particular database.. and getting the output in the specified file properly..

but after that , i was trying to remove the last line of the output of sql query like "24 rows selected" using grep command -

grep -v 'rows' $INPUT_FILE > $OUTPUT_FILE

where i am unable to get the output correctly..
can anyone help me out in finding exactly what may be the reason for this issue..

thnaks and regards,

Krips.

hi,

can i know if i am using connecting sql plus properly or not..

as of now i am giving it like

sqlplus -s user/pass@db -i sql.sql -o sql.sql.01

in the sql.sql i am having the contents like this -

select STATEMENT
quit

the output of this select statement into sql.sql.01 ...
with this am i properly exiting out of the sqlplus??

in the grep command i will be using this sql.sql.01 file as its input..
hope you all got a better idea about wat i am trying to do.. i think, i am screwing up something with my sqlplus connection...is it so??

all your sugestions are appreciated...

thanks,

Krips.

I'm guessing $INPUT_FILE is not set to what you think it's set to, or doesn't contain what you think it contains. How exactly are you generating the file, and assigning its name to a variable? Why aren't you pipiing the output through grep at the point when it is stored in a file in the first place? Or if it's always the last line you want to get rid of, try sed '$d'

hi era,

the problem was with the sqlplus connection only.. even though i was getting the correct output then also, there was something wrong..

now i am able to connect to sqlplus properly and am getting the output correctly..thanks for all your help..

but am having one doubt regarding spool command. Will we be getting a .lst file by default as output of spool command.

eg : consider that i am giving the spool command like this..

spool /path/file
SQL QUERY
spool off;

i was said by someone that if we use spool command then by default we will be getting the output in a .lst file ..is it so? please go through the link also..
https://www.unix.com/shell-programmin...-spooling.html

hope you can clear my doubt..

thanks,

Krips.