08-20-2008
try adding EOF
sqlplus -L username/passwd@sid << EOF > /dev/null
EOF
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I would like to run the following as bash script
sql -U history
update feed_domain_configuration
set enabled=1
where domain='lon' and vendor_name='<lond'
-sam (3 Replies)
Discussion started by: sam786
3 Replies
2. UNIX for Dummies Questions & Answers
I am using SUSE OS and want to check internet connection...
I have tried:
ping -c3 google.com
The output i have got is:
Unknown host google.com
does it means that i do not have Internet connection??
Or please help me with any Command to find Internet connection?
Thanks for any help. (1 Reply)
Discussion started by: salil2012
1 Replies
3. Shell Programming and Scripting
Hi,
I am using "ksh" and trying to connect to the Microsoft SQL Server but it gives an error that is:
DB-LIBRARY error:
Unexpected EOF from SQL Server.
Can any one please help me to resolve this issue. And i am using Putty to connect to the Unix server.
Thanks (3 Replies)
Discussion started by: anupdas
3 Replies
4. Shell Programming and Scripting
I "inherited" these scripts which are used to access an Oracle DB on a test envoiroment. Originaly someone from our security team would add an system user and password to the otherwise finished script and encrypt the whole thing. The encrypted file (script.x) would then be scheduled with Control-M.... (7 Replies)
Discussion started by: dani_nonato
7 Replies
5. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
6. Shell Programming and Scripting
Hi,
I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data.
Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Discussion started by: lsantacana
4 Replies
7. Programming
Hi.
I am writing client - server application using TCP sockets.
I need some very basic functionality, namely: how to check if another "participant" of the connection is still present?
I want to handle situations, when client is gone, or server breaks down, etc. (25 Replies)
Discussion started by: Shang
25 Replies
8. UNIX for Dummies Questions & Answers
I installed an odbc driver and created a DSN to connect to a sql server database on AIX 6. I want to know how to test the DSN from the command line. What syntax or commands do I use?
---------- Post updated at 11:44 AM ---------- Previous update was at 08:26 AM ----------
OK I figured out how... (9 Replies)
Discussion started by: Jdbrown239
9 Replies
9. UNIX for Dummies Questions & Answers
Hi,
i have to perform a connection from unix to sql server database, using TCP protocol.
I have all connection parameters (user,pwd,server_name,port,db_name).
How can i perform this connection, by unix console ?
is it available a command similar to this one (for oracle):
sqlplus... (1 Reply)
Discussion started by: nash83
1 Replies
10. UNIX for Beginners Questions & Answers
Hello ,
Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this..
How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies
LEARN ABOUT FREEBSD
tcopy
TCOPY(1) BSD General Commands Manual TCOPY(1)
NAME
tcopy -- copy and/or verify mag tapes
SYNOPSIS
tcopy [-cvx] [-s maxblk] [src [dest]]
DESCRIPTION
The tcopy utility is designed to copy magnetic tapes. The only assumption made about the tape layout is that there are two sequential EOF
marks at the end. By default, the tcopy utility will print information about the sizes of records and files found on the /dev/sa0 tape, or
on the tape specified by the src argument. If a destination tape is also specified by the dest argument, a copy of the source tape will be
made. The blocking on the destination tape will be identical to that used on the source tape. Copying a tape will yield the same program
output as if just printing the sizes.
The following options are available:
-c Copy src to dest and then verify that the two tapes are identical.
-s maxblk Specify a maximum block size, maxblk.
-v Given the two tapes src and dest, verify that they are identical.
-x Output all informational messages to the standard error instead of the standard output. This option is useful when dest is given
as /dev/stdout.
SEE ALSO
mt(1), mtio(4)
HISTORY
The tcopy command appeared in 4.3BSD.
BUGS
Writing an image of a tape to a file does not preserve much more than the raw data. Block size(s) and tape EOF marks are lost which would
otherwise be preserved in a tape-to-tape copy.
End of data (EOD) is determined by two sequential EOF marks with no data between them. There used to be old systems which typically wrote
three EOF's between tape files. The tcopy utility will erroneously stop copying early in this case.
When using the copy/verify option -c, tcopy does not rewind the tapes prior to start. A rewind is performed after writing, prior to the ver-
ification stage. If one does not start at the beginning-of-tape (BOT) then the comparison may not be of the intended data.
BSD
December 20, 2006 BSD