isql query in unix shell script Post: 302145337

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell...

2. Shell Programming and Scripting

A simple query on unix shell script

I want to write a script to go to particular path in file and run shell script from there. what will be shell script for the same.

3. Shell Programming and Scripting

Setting variable for query using iSql / Korn Shell

Hi All- First time using iSql. I have 4 query files - some have more than 1 line of sql statements After a bit of research it appears I can just use the -i command and specify the input file. Questions: Does it matter that there are multiple queries in each file? Do I need to have...

4. UNIX for Dummies Questions & Answers

executing SQL query using unix shell script

I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful.

5. Shell Programming and Scripting

Isql query in unix shell

Hi i want write a script for list of sysbase are having access or open. then i wrote like: USER="abc" PASS="xyz" SERVER="SCCS" DB="blue" WORK_DIR="/usr/home/ramakrishna" set -x isql -U${USER} -P${PASS} -S${SERVER}<<EOF>$WORK_DIR/output.log go use blue (database name) go use...

6. Shell Programming and Scripting

isql out in shell script

Hi I wrote a script for connecting isql(Sybase database) and stored the SQL output in Unix box. my script: isql -U${USER} -P${PASS} -S${SERVER} <<EOF > $WORK_DIR/out1.log go select convert(varchar(10),sdcurrent,101) from pr_sysdate go exit EOF Unfortunately, the output file not...

7. Shell Programming and Scripting

Unix shell script to query linux top consuming processes

Hi All, O/S: Linux 86x64 Red Hat I have a sql script that queries top consuming processes of Linux using TOP commnd. Now I need to automate this task and pass the top processes i.e., PID to the sql script through unix shell script. Could anyone please let me know how to achieve this. ...

8. Shell Programming and Scripting

Help With isql in shell script

Hello I am not able to get the isql output to temp_res file ... i have tried all the different combinations as shown below, but could not get anywhere .... Please Help isql -S $serv_name -U $usr_name -P $pswd -D $db_name -o temp_res << EOF1 select status from modset where...

9. Shell Programming and Scripting

Need Help with isql in Shell Script

Hi Guys, I need help with my code. I am not able to find what the error is (tried debugging and everything). #! /bin/sh # MODSET_CLOSE # Usage: modset_close echo "Enter the Type of Modsets that needs to be Closed: " read mod_typ serv_name=`cat $mod_typ | awk '{ print $1 }'`...

10. Shell Programming and Scripting

Using Isql for SQL SERVER to get the table rows counts in UNIX shell script to

need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix) i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable. isql -v DSN USERNAME PASSWD ...

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)