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
sieveshell
SIEVESHELL(1) User Contributed Perl Documentation SIEVESHELL(1)
NAME
sieveshell - remotely manipulate sieve scripts
SYNOPSIS
sieveshell [--user=user] [--authname=authname] [--realm=realm] [--password=password] [--exec=script] [--execfile=file] server[:port]
sieveshell --help
DESCRIPTION
sieveshell allows users to manipulate their scripts on a remote server. It works via MANAGESIEVE, a work in progress.
The following commands are recognized:
list list scripts on server.
put <filename> upload script to server.
get <name> [<filename>] get script. if no filename display to stdout
delete <name> delete script.
activate <name> activate script.
deactivate deactivate all scripts.
OPTIONS
-u user, --user=user
The authorization name to request; by default, derived from the authentication credentials.
-a authname, --authname=authname
The user to use for authentication (defaults to current user).
-r realm, --realm=realm
The realm to attempt authentication in.
-p password, --password=password
The password to use when authenticating to server. Note that this parameter can be seen in the process list. Use with caution!
-e script, --exec=script
Instead of working interactively, run commands from script, and exit when done.
-f file, --execfile=file
Instead of working interactively, run commands from file file and exit when done.
REFERENCES
[MANAGESIEVE] Martin, T.; "A Protocol for Remotely Managing Sieve Scripts", draft-ietf-managesieve-03.txt, Mirapoint, Inc.; May 2001, work
in progress.
AUTHOR
Tim Martin <tmartin@mirapoint.com>, and the rest of the Cyrus team <cyrus-bugs@andrew.cmu.edu>.
perl v5.14.2 2014-06-03 SIEVESHELL(1)