06-11-2016
Thanks a lot! That worked perfectly.
however this time my script for monitoring DB file system utilization is the new problem. when i enter isql, i just simply paste the "long script" (when i do this manually) but this time it's not executing automatically. Seems vi is still reading it as Unix script whereas should be in isql.
any advise on this?
---------- Post updated at 08:16 PM ---------- Previous update was at 07:25 PM ----------
Hi RudiC
I solved my issue above, just echo the whole 'long script'. My problem is now solved.
Thank you so much for your help!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
:1,10 s/yes/no/g
this ex command will substitute yes with no everytime it is found within the first 10 lines of the file.
:s/yes/no/g
this ex command will substitute yes with no everytime it is found for the line where the cursor is on
my question is how could this substitution be... (4 Replies)
Discussion started by: theDirtiest
4 Replies
2. UNIX for Dummies Questions & Answers
I want to copy lines say from 2-5 to line after 20 in vi editor. Can I achieve this in a single command in vi editor.
Thanks. (2 Replies)
Discussion started by: tselvanin
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
My systems manager wrote some reports using isql's 'ace' reporting program. He wants me to run these monthly from cron. Can this be done? can I run these reports from the command line(from a shell script)?
Thanks! (0 Replies)
Discussion started by: pugsly62
0 Replies
4. Shell Programming and Scripting
Hi,
I need to connect to DB through my shell script. but I dont want to hardcode my db password in the script. Is there a way to do it?
Thanks
---------- Post updated at 07:42 PM ---------- Previous update was at 04:54 PM ----------
:(Guys..please help me with this:( (1 Reply)
Discussion started by: agrawal.prachi
1 Replies
5. Red Hat
I am using Linux RHEL5 64 bit and installed oracle 11g.
I want to check ODBC connection , i had modified odbc.ini file
when i use this command -isql
I am getting following error .
bash: isql: command not found
Kindly help (5 Replies)
Discussion started by: roopalidalvi231
5 Replies
6. Red Hat
Hi,
I am using RHEL4 and Oracle11g , my application requires odbc connection
hence I modified ODBC.ini file and when I exceute isql commande I got the following error.
isql: error while loading shared libraries: /opt/nastel/apwmq/odbc/lib/libodbc.so.1: requires glibc 2.5 or later dynamic... (1 Reply)
Discussion started by: roopalidalvi231
1 Replies
7. Red Hat
Hi,
I am using RHEL4 and Oracle11g , my application requires odbc connection
hence I modified ODBC.ini file and when I exceute isql commande I got the following error.
isql: error while loading shared libraries: /opt/nastel/apwmq/odbc/lib/libodbc.so.1: requires glibc 2.5 or later dynamic... (4 Replies)
Discussion started by: roopalidalvi231
4 Replies
8. AIX
HI ,
I'm facing the FTP connection refused from text editor while accessing AIX server .It showing the messege "can't create ftp connection connectin refused".Though it is accessible from putty .
i'm using aix version 6 .
Can any one let me know the seetings needs to be made so that i... (2 Replies)
Discussion started by: rmkganesh
2 Replies
9. Shell Programming and Scripting
I am trying to run a query which returns a sum value(a number).
I want to get it in a variable so that i can refer to that variable in different places.
when i am running the following command
variable=`isql -Uuser -Sserver -Ppassword
1> select sum(count(*)) from xyz..abc where clm_id... (2 Replies)
Discussion started by: Sharma331
2 Replies
10. Shell Programming and Scripting
I am using ISQL command in ksh script.
Suppose if i get NULL value from the query which i run,how can i handle it?
I am getting a NULL result set and the following error is coming.
############### output of isql command for getting the sum of JEs ################
-----------
NULL... (4 Replies)
Discussion started by: Sharma331
4 Replies
osql(1) FreeTDS Utilities osql(1)
NAME
osql - utility to test FreeTDS connections and queries
SYNOPSIS
osql -S dsn -U username -P password [-I ini_dir]
DESCRIPTION
osql is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
everything checks out OK, it invokes isql.
osql works only with the isql that comes with unixODBC.
OPTIONS
-S dsn the Data Source Name to which to connect, as known to odbc.ini.
-U username
database login name.
-P password
database password.
-I ini_dir
override odbc.ini file location.
EXAMPLE
If you have an odbc.ini with a section like this:
[myDSN]
servername = myserver
TDS_Version = 5.0
You would invoke osql as:
osql -S myDSN [...]
NOTES
If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.
osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach. If it doesn't
work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.
If osql cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully at the error output before
overriding.
If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.
HISTORY
osql first appeared in FreeTDS 0.65.
AUTHORS
The osql utility was written by James K. Lowden
doc 13 November 2011 osql(1)