08-08-2005
Connect to sybase database using Korn shell script
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
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
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... (3 Replies)
Discussion started by: Aparna_k82
3 Replies
3. Shell Programming and Scripting
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies
4. Shell Programming and Scripting
I have got the solution so just closing this issue. (3 Replies)
Discussion started by: jambesh
3 Replies
5. Windows & DOS: Issues & Discussions
hi,
I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys.
The database is running on solaris 10.
I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Discussion started by: danin
3 Replies
6. Shell Programming and Scripting
I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Discussion started by: tjhanso
1 Replies
7. Shell Programming and Scripting
Hello,
I want to connect to Database through shell command line.
Here is my command from putty,
$ sqlplus -S ora/ora@ORA
But I am not able to connact to database.
If this command succed, what is the expected output on shell prompt?
Could you please let me know how to connact to... (3 Replies)
Discussion started by: Poonamol
3 Replies
8. Shell Programming and Scripting
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
Discussion started by: jackmorgan2007
2 Replies
9. Shell Programming and Scripting
Hi Unix Gurus,
I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to proceed the next job application or when an error when connectiong to DB it should not generate any... (8 Replies)
Discussion started by: bshivali
8 Replies
10. Shell Programming and Scripting
Hi All,
I am newbie to unix shell scripting. I want to connect to oracle database using shell script. I know how to connect DB using user name and password but my question is if my password is having '@' sign then how to connect.
I have tried like below,
cnt=`sqlplus -s /nolog << EOFSQL
... (3 Replies)
Discussion started by: pmotewar
3 Replies
LEARN ABOUT CENTOS
pppoe-connect
PPPOE-CONNECT(8) System Manager's Manual PPPOE-CONNECT(8)
NAME
pppoe-connect - Shell script to manage a PPPoE link
SYNOPSIS
pppoe-connect [config_file]
pppoe-connect interface user [config_file]
DESCRIPTION
pppoe-connect is a shell script which manages a PPPoE connection using the Roaring Penguin user-space PPPoE client. If you omit con-
fig_file, the default file /etc/sysconfig/network-scripts/ifcfg-ppp0 is used. If you supply interface and user, then they override the
Ethernet interface and user-name settings in the configuration file.
Note that normally, you should not invoke pppoe-connect directly. Instead, use pppoe-start to bring up the PPPoE connection.
pppoe-connect first reads a configuration file. It then brings up a PPPoE connection. If the connection ever drops, a message is logged
to syslog, and pppoe-connect re-establishes the connection. In addition, each time the connection is dropped or cannot be established,
pppoe-connect executes the script /etc/ppp/pppoe-lost if it exists and is executable.
The shell script pppoe-stop causes pppoe-connect to break out of its loop, bring the connection down, and exit.
TECHNICAL DETAILS
pppoe-connect uses the following shell variables from the configuration file:
ETH The Ethernet interface connected to the DSL modem (for example, eth0).
USER The PPPoE user-id (for example, b1xxnxnx@sympatico.ca).
PIDFILE
A file in which to write the process-ID of the pppoe-connect process (for example, /var/run/pppoe.pid). Two additional files ($PID-
FILE.pppd and $PIDFILE.pppoe) hold the process-ID's of the pppd and pppoe processes, respectively.
By using different configuration files with different PIDFILE settings, you can manage multiple PPPoE connections. Just specify the con-
figuration file as an argument to pppoe-start and pppoe-stop.
AUTHOR
pppoe-connect was written by David F. Skoll <dfs@roaringpenguin.com>.
The pppoe home page is http://www.roaringpenguin.com/pppoe/.
SEE ALSO
pppoe(8), pppoe-start(8), pppoe-stop(8), pppd(8), pppoe.conf(5), pppoe-setup(8), pppoe-status(8), pppoe-sniff(8), pppoe-server(8), pppoe-
relay(8)
4th Berkeley Distribution 21 February 2000 PPPOE-CONNECT(8)