Sponsored Content
Top Forums UNIX for Dummies Questions & Answers SQL Connection check though Scripting Post 302226838 by vidyadhar85 on Wednesday 20th of August 2008 04:04:53 AM
Old 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

sql scripting help

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

check Internet connection?

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

Connection to Microsoft SQL Server

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

Help with SQL*Plus Connection

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

Execute multiple SQL scripts from single SQL Plus connection

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

SQL query in a loop with single sqlplus connection

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

TCP connection check

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

Test new DSN connection to sql server

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

UNIX string connection to sql server db

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

How to use for loop to execute multiple .sql files while using SQLPLUS for db connection.?

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
getfsent(3X)															      getfsent(3X)

NAME
getfsent(), getfsspec(), getfsfile(), getfstype(), setfsent(), endfsent() - get file system descriptor file entry SYNOPSIS
Remarks: These routines are included only for compatibility with 4.2 BSD. For maximum portability and improved functionality, new applications should use the getmntent(3X) library routines. DESCRIPTION
and each returns a pointer to an object with the following structure containing the broken-out fields of a line in the file. The structure is declared in the header file: The fields have meanings described in fstab(4). If the block special file name, the file system directory name, and the type are not all defined on the associated line in these routines return pointers to NULL in the and fields. If the pass number or the backup frequency field are not present on the line, these routines return -1 in the corresponding structure member. is reserved for future use. Reads the next line of the file, opening the file if necessary. Opens and rewinds the file. Closes the file. Sequentially searches from beginning of file until a matching special file name is found, or until EOF is encountered. Sequentially searches from the beginning of the file until a matching file system file name is found, or until EOF is encountered. Sequentially searches from the beginning of the file until a matching file system type field is found, or until EOF is encountered. DIAGNOSTICS
A null pointer is returned on EOF, invalid entry, or error. WARNINGS
Since all information is contained in a static area, it must be copied to be saved. Obsolescent Interfaces and are to be obsoleted at a future date. AUTHOR
was developed by HP and the University of California, Berkeley. FILES
SEE ALSO
fstab(4). TO BE OBSOLETED getfsent(3X)
All times are GMT -4. The time now is 07:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy