02-17-2006
to connect to sybase you can use isql from your unix script, or odbc if you are programming in c o perl.
the isql syntax is like this:
#!/bin/ksh
DOWN()
{
isql -b -U$user -P$password -S$server -o$output <<END
go
go
sql statement
go
END
}
user=xxxxxx
password=yyyy
server=zzz
DOWN
anyway you can search for isql in this forum..
bye.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello..
Please helppppppp...!!!
I am using SCO Open Server version 5.0 at work. I am trying to find a third party software to use on my computer at home which has windows 98 on it to do remote connect to my work. Is there any such software ? I know there is PC ANYWHERE but i don't think it... (2 Replies)
Discussion started by: jackpotp
2 Replies
2. Windows & DOS: Issues & Discussions
Hi all,
I am trying to connect to Remote Sybase database Server through shell script. I am operating on WindowsXP, connect to Unix(version SunOS: 5.8)
The thing is i dont know how to connect to Sybase Server through my script file?
Are there any manual pages which can guide me through the... (2 Replies)
Discussion started by: Aparna_k82
2 Replies
3. Shell Programming and Scripting
Hi,
Can anyone please give me a script or let me know how to connect to a sybase database and execute a query using Korn shell scripts.Am new to Unix but i need to do this ASAP.
Please help.
Thanks,
Gops (7 Replies)
Discussion started by: bhgopi
7 Replies
4. Shell Programming and Scripting
i want to connect to a remote server through ssh.
i have to also provide password within that script.
after connecting to the remote server i want to do some operations like grep,cd etc
can u pls help me to wite a script.
Thanks (1 Reply)
Discussion started by: millan
1 Replies
5. Shell Programming and Scripting
Hello All
I need a script or set of commands which can establish a remote connection with another server and execute some scripts over there. Basically it has to establish the connection with the remote server as an user ,say 'testuser' and then execute the script 'testscript'. and return the... (5 Replies)
Discussion started by: sgbhat
5 Replies
6. UNIX for Dummies Questions & Answers
Hi, how do I connect to a remote x server?
i tried this:
startx -display 192.168.0.1:0
# when I do this, it just connects to my own x server i.e I see my own desktop.
and
export DISPLAY=192.168.0.1:0.0
# when I do this nothing happens. (it doesn't even try to connect, no activity in... (7 Replies)
Discussion started by: uxfuser
7 Replies
7. Red Hat
hi all
i am unable to connect remote server using ssh but i am able to ping the server
ssh service is running. (5 Replies)
Discussion started by: nikhil kasar
5 Replies
8. HP-UX
I am trying to connect to remote server in hp-ux, using sftp command (using sftp username@ip and password ) able to connect to remote server but, in this case sftp prompt for password and user need to manually enter it.
I want sftp can read a password define in script or from file, so it can... (1 Reply)
Discussion started by: ketanraut
1 Replies
9. Shell Programming and Scripting
Hello Every one!!
I am trying to write a shell script which will connect to a remote server and execute scripts which are at a certain path in the remote server.
Before this I am using a sudo command to change the user.
The place where I am stuck is, I am able to connect to the... (6 Replies)
Discussion started by: masubram
6 Replies
10. Shell Programming and Scripting
I have a script, which connecting to remote server and first checks, if the files are there by timestamp. If not I want the script exit without error. Below is a code
TARFILE=${NAME}.tar
TARGZFILE=${NAME}.tar.gz
ssh ${DESTSERVNAME} 'cd /export/home/iciprod/download/let/monthly;... (3 Replies)
Discussion started by: digioleg54
3 Replies
LEARN ABOUT DEBIAN
apache::session::lock::sybase
Apache::Session::Lock::Sybase(3pm) User Contributed Perl Documentation Apache::Session::Lock::Sybase(3pm)
NAME
Apache::Session::Lock::Sybase - Provides mutual exclusion using Sybase
SYNOPSIS
use Apache::Session::Lock::Sybase;
my $locker = new Apache::Session::Lock::Sybase;
$locker->acquire_read_lock($ref);
$locker->acquire_write_lock($ref);
$locker->release_read_lock($ref);
$locker->release_write_lock($ref);
$locker->release_all_locks($ref);
DESCRIPTION
Apache::Session::Lock::Sybase fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through the use of Sybase's
sp_getapplock and sp_releaseapplock functions. Sybase does not support the notion of read and write locks, so this module only supports
exclusive locks. When you request a shared read lock, it is instead promoted to an exclusive write lock.
CONFIGURATION
The module must know how to connect to your MySQL database to acquire locks. You must provide a datasource name, a user name, and a
password. These options are passed in the usual Apache::Session style, and are very similar to the options for
Apache::Session::Store::Sybase. Example:
tie %hash, 'Apache::Session::Sybase', $id, {
LockDataSource => 'dbi:sybase:database',
LockUserName => 'database_user',
LockPassword => 'K00l'
};
Instead, you may pass in an already opened DBI handle to your database.
tie %hash, 'Apache::Session::Sybase', $id, {
LockHandle => $dbh
};
AUTHOR
This module was written by Oliver Maul <oli@42.nu>.
SEE ALSO
Apache::Session
perl v5.10.1 2010-10-18 Apache::Session::Lock::Sybase(3pm)