Sponsored Content
Top Forums Shell Programming and Scripting permanent redirection of standard input Post 302094738 by aigles on Tuesday 31st of October 2006 11:00:44 AM
Old 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.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Input Redirection

Hi everybody, first of all i am a new member in UNIX.com and this is my first post. I am impressed with the amount of information a person can ever have in this forum, it is really great having something similiar; anyways let me tell you about the problem I am having, hope you will answer me.... (6 Replies)
Discussion started by: majeed73
6 Replies

2. Shell Programming and Scripting

Standard output and redirection

Hello, Is is possible to redirect stdout to a file as well as to the console/screen or display in ksh. any thoughts suggestions/input is appreciated. Thanks. (2 Replies)
Discussion started by: jerardfjay
2 Replies

3. Shell Programming and Scripting

standard input

how can i redirect standard input? i dont remember :/, though could you redirec not from a command? i mean, to redirect always stdin and stout (1 Reply)
Discussion started by: Jariya
1 Replies

4. Shell Programming and Scripting

input redirection question

Hi, in my script I need to execute the following command: query $id 456 432 but it waits for a RETURN character from keyboard and therefore, it fails. I tried something like: query $id 456 432 << '\n' but, i'ts clear it is not correct. Is there any way to do this? Thxs. (0 Replies)
Discussion started by: luistid
0 Replies

5. Shell Programming and Scripting

Input redirection and for loop

Hello, I need help with a bash script that I try to improve. I could not find answer so far, maybe because I'm not to familiar with the terminology so feel free to correct my language. I have a script that looks like: NODES="node_a node_b node_c" for NODE in $NODES do ... (4 Replies)
Discussion started by: pn8830
4 Replies

6. Shell Programming and Scripting

Standard output redirection from a variable

Hi, trying to store a comand involving a redirection in a variable and then run this variable. But the redirection gets lost. Ex: #!ksh MYCMD="ls -l > dirlist.txt" $MYCMD This runs the command but displays the result in the terminal instead of redirecting it to the text file. Can... (4 Replies)
Discussion started by: rm-r
4 Replies

7. Solaris

standard input

Please give me any example for standard input in Solaris. (6 Replies)
Discussion started by: karman0931
6 Replies

8. UNIX for Dummies Questions & Answers

When do I use input redirection?

Can someone please explain when input redirection is necessary? For example, "cat filename" and "cat< filename" produce the same result. I was told that if I need to bunzip a file that I should type "bunzip2<filename.bz2." However, if I omit the "<" I still get the same result. Can someone... (4 Replies)
Discussion started by: PTcharger
4 Replies

9. Homework & Coursework Questions

Removing punctuations from file input or standard input

Just started learning Unix and received my first assignment recently. We haven't learned many commands and honestly, I'm stumped. I'd like to receive assistance/guidance/hints. 1. The problem statement, all variables and given/known data: How do I write a shell script that takes in a file or... (4 Replies)
Discussion started by: fozilla
4 Replies

10. Shell Programming and Scripting

Input redirection script

Hi, #!/bin/bash while ; do rm -f /tmp/pipe mkfifo /tmp/pipe ./yuv4mpeg_to_v4l2 < /tmp/pipe & mplayer tom_and_jerry.mp4 -vf scale=480:360 -vo yuv4mpeg:file=/tmp/pipe sleep 65; done When I run this - after mplayer finishes playing video it says - Exiting... (End of... (2 Replies)
Discussion started by: ashokvpp
2 Replies
rsh(1c) 																   rsh(1c)

Name
       rsh - remote shell

Syntax
       rsh host [-l username] [-n] command
       host [-l username] [-n] command

Description
       The  command  connects to the specified host, and executes the specified command.  The command copies its standard input to the remote com-
       mand, the standard output of the remote command to its standard output, and the standard error of the remote command to its standard error.
       Interrupt, quit and terminate signals are propagated to the remote command.  The command normally terminates when the remote command does.

       The  remote  username  used is the same as your local username, unless you specify a different remote name with the -l option.  This remote
       name must be equivalent, in the sense of to the originating account.  No provision is made for specifying a password with a command.

       If you omit command, then instead of executing a single command, you are logged in on the remote host using

       Shell metacharacters which are not quoted are interpreted on local machine, while quoted  metacharacters  are  interpreted  on  the  remote
       machine.  Thus the command

	  rsh otherhost cat remotefile >> localfile

       appends the remote file remotefile to the localfile localfile, while

	  rsh otherhost cat remotefile ">>" otherremotefile

       appends remotefile to otherremotefile.

       Host  names are given in the file Each host has one standard name (the first name given in the file), which is rather long and unambiguous,
       and optionally one or more nicknames.  The host names for local machines are also commands in the directory If you put  this  directory	in
       your search path then the can be omitted.

Options
       -l username	   Logs you in as the specified user, not as your user login name.

       -n		   Redirects all command input to

Restrictions
       The  command  is  confused by output generated by commands in a .cshrc file on the remote host.	In particular, `where are you?' and `stty:
       Can't assign requested address' are messages which can result if output is generated by the startup file.

       If you are using and put a in the background without redirecting its input away from the terminal, it blocks even if no reads are posted by
       the remote command.  If no input is desired you should redirect the input of to using the -n option.

       You cannot run an interactive command like Use

       Stop signals stop the local process only.

Files
       /etc/hosts
       /usr/hosts/*

See Also
       rlogin(1c)

																	   rsh(1c)
All times are GMT -4. The time now is 01:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy