Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: isql input file with multiple sql statements
Top Forums Shell Programming and Scripting isql input file with multiple sql statements Post 302288195 by Cailet on Monday 16th of February 2009 05:08:35 PM
Old 02-16-2009
isql input file with multiple sql statements
I've got:
isql -U $USERID -S $SERVER -D $DATABASE -i inputfile.sql -o outputfile.txt

in inputfile I have:
go
sql#1
go
sql#2
go
sql#3
go

I also tried without "go" and with";" instead which did not work
SQL statements will work if I paste them directly into the script and use EOF

Any ideas why they won't work as an input file?
 

10 More Discussions You Might Find Interesting

1. Solaris

Automate SQL statements

Hello, On unix side, I have written below script for taking oracle db backup. But when I tried to execute it - i could not execute the sql statements from unix. Please suggest ------------------------ $ more bkp.sh #!/bin/ksh # make sure database is shutdown cleanly sqlplus '/ as sysdba'... (3 Replies)
Discussion started by: panchpan
3 Replies

2. Solaris

bcp and isql for MS SQL Server on Solaris?

After dumping data from an Oracle database running on Solaris into a flat file, we need to run bcp and isql for MS SQL Server on the same Solaris box. Does Microsoft provide some tools that run on Unix? Thanks for your assistance. (2 Replies)
Discussion started by: tomstone_98
2 Replies

3. Shell Programming and Scripting

put value of multiple sql statements into unix variables

i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement. (1 Reply)
Discussion started by: sw@pnil
1 Replies

4. UNIX for Dummies Questions & Answers

store SQL statements and results in a file

Hello Guys... I want a small help from you guys. Actually in Oracle, we are having a utlity called spool through which can store whatever SQL statements executed and other queries and the output of those queries in a file So, similarly in Unix, if I start a session executing a number of Unix... (2 Replies)
Discussion started by: mraghunandanan
2 Replies

5. Shell Programming and Scripting

Remover Banner and SQL prompt from isql

Hi, I am using isql and putting the output in a file in a shell script in Linux. However in my output i am getting the banner and a SQL prompt(at the start and the end of query output) +---------------------------------------+ | Connected! | | ... (6 Replies)
Discussion started by: lifzgud
6 Replies

6. Shell Programming and Scripting

Multiple if statements in script and unexpected end of file

Two things... 1) If I have an if statement that is true I want it to exit without running the rest of the file, but if it is false I want it to continue.. I just did if ; then exit else echo "" fi Can that work? I want it to exit if $1 is 0, and if not to continue running the rest of the... (1 Reply)
Discussion started by: glev2005
1 Replies

7. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

8. UNIX for Dummies Questions & Answers

SQL Script to use variable value from input file

Here is the requirement, When I run the "run file KSH (sql)", it should substitute '${pCW_Bgn_DT}' with 201120 and '${pCW_End_DT}' with 201124 Input File ---------- $ cat prevwk.dat 201124 20110711 run file KSH (sql) ------------------ In this file, I want to use the variables... (1 Reply)
Discussion started by: shanrice
1 Replies

9. Shell Programming and Scripting

Create SQL DML insert statements from file using AWK or similar

Hi all. This is my first post on this forum. I've previously found great help in the huge knowledgebase that is here, but this time I have not been able to find a solution to my problem. I have a large text file that looks like this: typedef struct ABC_struct_nbr1_ { char attr1; /*... (0 Replies)
Discussion started by: Yagi Uda
0 Replies

10. Shell Programming and Scripting

Regarding file input to SQL from command line

Hi friends, Need your help again to get a best approach for the below scenario. I am previously having one shell script which accepts request_id/s as the command line argument. single req_id arg= 1111 Multiple arg= 1111,2222,3333 which gets passed to the embedded sql inside to... (9 Replies)
Discussion started by: Showdown
9 Replies

LEARN ABOUT DEBIAN

isql

isql(1) 							UnixODBC Reference							   isql(1)

NAME

       isql - utility to submit SQL queries to a data source.
       iusql - Unicode version of isql.

SYNOPSIS

       isql DSN [UID [PWD]] [options]

DESCRIPTION

       isql can be used to submit SQL to a data source and to format/output results.  It can be used in batch or interactive mode.

OPTIONS

       DSN    Name of the data source you want to connect to.

       UID    Your login to connect the DSN.

       PWD    Your password needed to login to the DSN.

       -b     Batch mode.  It will not do any prompting.

       -dx    Delimit columns with x.

       -x0xXX Delimit columns with XX, where XX is in hex.  For example -x0x09 will use a tab.

       -w     Wrap results in an HTML table

       -c     Print column names on first row.	This options only has effect in combination with the -d option.

       -mn    Limit column display width to n

       -v     Verbose output.

       --version
	      This prints the version.

EXAMPLES

       cat My.sql | isql WebDB MyID MyPWD -w
	      Each line in My.sql must contain exactly 1 SQL command except for the last line which must be blank.

AUTHOR

       This manual page was written by Kurt Roeckx <kurt@roeckx.be> for the Debian package of unixODBC.

UnixODBC							     Dec 2004								   isql(1)
All times are GMT -4. The time now is 12:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy