06-11-2016
Hi RudiC
Thanks for your reply, sorry to get you confused. Reason why i execute "exit" on su - sybsid line is to just get any response or error in my script as to why it does not execute the isql line.
Is the su - sybsid line really interactive? Meaning i really should execute isql line everytime i run the file in order for my script to continue? I was thinking of eliminating any interaction so it does save me time as i need to do these on multiple systems.
Appreciate your reply. Thanks so much.
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
LEARN ABOUT DEBIAN
bsqlodbc
bsqlodbc(1) FreeTDS Utilities bsqlodbc(1)
NAME
bsqlodbc - batch SQL script processor using ODBC
SYNOPSIS
bsqlodbc [-U username] [-P password] [-S server] [-D database]
[-i input_file] [-o output_file] [-e error_file]
[-t field_term] [-qv]
DESCRIPTION
bsqlodbc is a utility program distributed with FreeTDS.
bsqlodbc is a non-interactive equivalent of the "isql" utility programs distributed by Sybase and Microsoft. Like them, bsqlodbc uses the
command "go" on a line by itself as a separator between batches. The last batch need not be followed by "go".
bsqlodbc makes use of the ODBC API provided by FreeTDS. This API is of course also available to application developers.
OPTIONS
-U username
Database server login name.
-P password
Database server password.
-S server
Database server to which to connect.
-D database
Database to use.
-i input_file
Name of script file, containing SQL.
-o output_file
Name of output file, holding result data.
-e error_file
Name of file for errors.
-t field_term
Specifies the field terminator. Default is two spaces (' '). Recognized escape sequences are tab (' '), carriage return ('
'),
newline ('
'), and backslash ('\').
-h Print column headers with the data to the same file.
-q Do not print column metadata, return status, or rowcount. Overrides -h.
-v Verbose mode, for more information about the ODBC interaction. This also reports the result set metadata, including and return
code. All verbose data are written to standard error (or -e), so as not to interfere with the data stream.
NOTES
bsqlodbc is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i, -o, and -e
options override these, of course.
EXIT STATUS
bsqlodbc exits 0 on success, and >0 if the server cannot process the query.
HISTORY
bsqlodbc first appeared in FreeTDS 0.65.
AUTHORS
The bsqlodbc utility was written by James K. Lowden <jklowden@freetds.org>
doc 13 November 2011 bsqlodbc(1)