permanent redirection of standard input - Shell Programming and Scripting

gfhgfnhhn · #1 (**permalink**) 10-31-2006

while running a user inter-active program
how can we get the commands from a
file instead of the user?

is there anyway to permanently redirect content
of a file to standard input?

aigles · #2 (**permalink**) 10-31-2006

You can do :

Code:

my_program < input_file

If you want the redirectition permanent within your script:

Code:

exec 1<input_file

Jean-Pierre

gfhgfnhhn · #3 (**permalink**) 10-31-2006

thanks for your reply but it didnt solve my problem.
let me explain via example:

i am running sqlplus, then in the sql prompt i am running some queries.

sqlplus user/pasw@DATABASE
SQL> select * from my_table1;
SQL>

but what i want to do is to feed these query statements to sqlplus
from a file.
an example file content can be like this:
select * from my_table1;
select * from my_table2;
select * from my_table3;

jim mcnamara · #4 (**permalink**) 10-31-2006

Code:

qry=`cat somefile`
sqlplus -s user/passwd@mydb<<EOF
spool myfile.lis
$qry
exit;
EOF

aigles · #5 (**permalink**) 10-31-2006

Two solutions to use with a file containing sql code.
First :

Code:

sqlplus user/pasw@DATABASE < sql_file

Second using sqlplus specific syntax :

Code:

sqlplus user/pasw@DATABASE @sql_file

Jean-Pierre.

gfhgfnhhn · #6 (**permalink**) 10-31-2006

what is spool?
i dont think that my OS supports a command named spool.
can u explain about it?

blowtorch · #7 (**permalink**) 11-01-2006

'spool' is an sql command. Any commands that lie between <<EOF and EOF are not interpreted by shell, but sent in to the sqlplus command for which the input is redirected.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Asking about shell script input output redirection	trivektor	Shell Programming and Scripting	1	10-17-2006 10:13 PM
input redirection question	luistid	Shell Programming and Scripting	0	08-22-2006 04:28 AM
standard input	Jariya	Shell Programming and Scripting	1	06-06-2006 08:49 AM
Standard output and redirection	jerardfjay	Shell Programming and Scripting	2	06-27-2005 08:03 AM
Input Redirection	majeed73	UNIX for Dummies Questions & Answers	6	07-08-2002 12:57 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode