sybase connection through shell-script

Amitabh · #1 (**permalink**) 03-03-2005

how do i connect to sybase through shell script written in linux

RTM · #2 (**permalink**) 03-03-2005

Impossible to write a shell script in Linux. Linux is the OS, not a shell.

Here is an example of a startup/shutdown script for Sybase:

Code:

#!/bin/sh
#
# Startup script for Sybase SQL server
#

#
# Adjust tcp's keepalive param to 10 mins for PCs which disconnect unexpectedly.
# Sun recommend that the value be set no lower than 10 minutes or performance
# may be affected.
#
/usr/sbin/ndd -set /dev/tcp tcp_keepalive_interval 600000

#
# Path to Sybase and install.
#
SYBASE=/usr/sybase

ISQL=$SYBASE/bin/isql

INSTALL=$SYBASE/install

export SYBASE ISQL INSTALL

case "$1" in
'start')
	#
	# Sybase server startup.
	#
	su sybase -c "$INSTALL/startserver -f $INSTALL/RUN_FOO -f $INSTALL/RUN_FOO_BACKUP &"
	;;

'stop')
	#
	# Sybase server shutdown.
	#
	$ISQL -S FOO -U sa -P password > /dev/console 2>&1 <<-'END'
	shutdown SYB_BACKUP
	go
	shutdown
	go
	END
	;;

*)
	#
	# Invalid param.
	#
	echo "Usage: /etc/init.d/sybase { start | stop }"
	;;
esac

ramaraju · #3 (**permalink**) 03-03-2005

I am a bit confused with the reply.
Shell feature does not exist on Linux unline in UNIX?

RTM · #4 (**permalink**) 03-03-2005

It's really simple - Linux is not a shell - it's a operating system. So it's impossible to write a 'linux' shell script. You can write shell scripts on a linux system but they would be one of the normal shells (sh,ksh,csh,bash,tcsh,...).

anthreedhr · #5 (**permalink**) 05-20-2005

RTM,

what does the
su sybase -c "$INSTALL/startserver -f $INSTALL/RUN_FOO -f $INSTALL/RUN_FOO_BACKUP &"

command do? Would it allow me to change between several interface files (that contain the sybase host info)?

If so, I noticed that you had 2 of them, so does that mean that you can utilize 2 (or more) different interface files to use to connect with ISQL?

Thanks,
Harold

RTM · #6 (**permalink**) 05-20-2005

Quote:

RTM,
what does the command do?
su sybase -c "$INSTALL/startserver -f $INSTALL/RUN_FOO -f $INSTALL/RUN_FOO_BACKUP &"

No clue - I don't know sybase! The assumption is that it starts both instances of sybase which I assume is the main database server and the backup service.
If it doesn't work with two -f instances, then create two different lines for each instead. The DBA who wrote this script doesn't work at my company anymore so I can't even ask him.

jingi1234 · #7 (**permalink**) 05-20-2005

I guess ..you are asking how to connect to sybase using shell script.

use here documents

ISQL -U -P -S -o output.txt ............ << EOF

Whatever you want to do in the sybase

EOF

The output will be written to that file specified with -o switch (in the above case --> output.txt).

Hope this helps.
Jingi

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
oracle connection from shell script	DILEEP410	Shell Programming and Scripting	4	07-01-2009 02:19 AM
Connecting to sybase via shell script.	arvindcgi	Shell Programming and Scripting	1	05-20-2008 10:30 AM
Connect to sybase database using Korn shell script	bhgopi	Shell Programming and Scripting	7	08-10-2005 09:34 AM
remote sybase connection and php error.	lealyz	Shell Programming and Scripting	4	08-23-2004 04:52 AM
shell script- oracle connection problem	nattynatty	Shell Programming and Scripting	4	08-14-2002 09:48 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: