isql out in shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting isql out in shell script
# 1  
Old 02-24-2010
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:


Code:
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 having the sql query out put.

Please advise on this

Last edited by pludi; 02-24-2010 at 10:38 AM.. Reason: code tags, please...
# 2  
Old 02-24-2010
Have you tested what you get using
isql -U${USER} -P${PASS} -S${SERVER}
and give those inputlines from stdin ?
Maybe ; needed in every sqlline - usually sql syntax need ;
# 3  
Old 02-25-2010
Yes... the isql has been connecting to Database... but not executing next commands.
Code:
Code:
USER="xyz"
PASS="abc"
SERVER="SCCS"
DB="blue"
WORK_DIR="/usr/home/genesys/Sayantan/ramakrishna"
set -x
	isql -U${USER} -P${PASS} -S${SERVER}<<EOF
	go
	sp_help NBEventLog	
	go
	exit
	EOF


Out put: 

+ isql -Uxyz -Pabc -SSCCS
+ 0< /var/tmp/sh14880.1
Msg 2409, Level 11, State 2:
Cannot find the requested character set in Syscharsets:  name = 'roman8'.
No conversions will be done.

I hope the isql not able recognize the EOF(stdin) in script.Please help me.
The Cannot find message are expecting in my isql.
# 4  
Old 02-25-2010
I've never used Sybase, but any SQL engine that I've used had a limited set of commands that were recognized. I don't think it can intrepret the EOF logic. In the past I have created a temp file in the stream of the script and then executed the isql (or similar) with a directive to use a file for command input and use the temp file there. This may be a good option for you.
# 5  
Old 02-25-2010
Thanks... Smilie
# 6  
Old 03-25-2010
If you do a search on sybase and scripts, you will find many threads about it. Many of them use the EOF with no issues - the one's I've notice do NOT use an exit - that maybe what is messing with your script.

See sybase connection through shell script as one example

and I'm not sure, but don't you need -o in your isql statement to specify the output file?
Code:
isql -U${USER} -P${PASS} -S${SERVER} <<EOF > -o $WORK_DIR/out1.log


Last edited by RTM; 03-25-2010 at 02:10 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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 ... (6 Replies)
Discussion started by: pimmit22043
6 Replies

2. 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 }'`... (5 Replies)
Discussion started by: gkrish
5 Replies

3. 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... (1 Reply)
Discussion started by: gkrish
1 Replies

4. UNIX for Dummies Questions & Answers

how to use shell variable in isql

Hi , I want to use shell variable in isql. example.. $ksh ./sudh.ksh "2041qwer" sudh.ksh is my script passing the perameter "2041qwer" Code in my script : =========== $SYBASE/$SYBASE_OCS/bin/isql -I$SYBASE/interfaces -S$OTHRSRVR -U$SYBUSER -P$SYBPASS -w... (1 Reply)
Discussion started by: sudhakarpasala
1 Replies

5. Shell Programming and Scripting

passing database password to isql command in shell script

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

6. Shell Programming and Scripting

Passing Shell Variables in ISQL

Hi.. I am passing a variable in my shell function. I need to access it for an isql comand in the shell script. However the isql o/p gives no results if i pass a variable in the command. The isql command works perfectly fine if i hardcore the table name. My script is : ... (0 Replies)
Discussion started by: dikki
0 Replies

7. Shell Programming and Scripting

ISQL Shell Script Question

I am trying to run the following Sybase SQL query in a shell script file. It isn't working although everything else in the file runs, and I can run queries from a file fine. For some reason, entering the query directly doesn't work. Any ideas? #!/bin/sh $SYBASE/$SYBASE_OCS/bin/isql -e... (2 Replies)
Discussion started by: andy_h
2 Replies

8. UNIX for Dummies Questions & Answers

Using isql in korn shell

Hi all, I have two accounts in a Unix server, the first one uses .tcsh as default shell and the other uses .ksh (korn shell) as default. When I login using the account with .tcsh default, I can use the isql command and connect to our database server. However, when I use the other... (2 Replies)
Discussion started by: risk_sly
2 Replies

9. Shell Programming and Scripting

isql query in unix shell script

Dear all I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below. isql -U -P use gdb_1 go select count (*) from table_x go (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies

10. Shell Programming and Scripting

isql in shell script help

Hello all... i'm trying to execute a shell script through crontab. To run at 8pm on wednesday's The crontab entry: 00 20 * * 3 /u2/dir1/dir2/jobs/p.sh the p.sh file: isql -s claims /u2/dir1/dir3/dir4/a.sql permissions for it are -rwxrwx--x i've confirmed a.sql is in that directory. ... (2 Replies)
Discussion started by: mrviking
2 Replies
Login or Register to Ask a Question