Cool_Buddy

 Profile Answers by Cool_Buddy 

• Apr 6th, 2006

 

Which database u want to connect to ?

anjani.unix.help

 Profile Answers by anjani.unix.help 

• Apr 12th, 2006

 

Suppose you are using db2 and ksh

----------------------------

#!/usr/bin/ksh

connect to <Serve Name>:<Port NO>@<Instance Name> user <USERID> using <Passwd>

-----------------------------------

If u have profile and catalog then

----------------------------------

#!/usr/bin/ksh

db2 connect to <SID>

-----------------------------------

To run a sample proc .. use the below

db2 "<Proc Name>"

Thanks,

an

vijay9849708008

 Profile Answers by vijay9849708008 

• Apr 19th, 2006

 

To Connect to Oracle Database and Collect the data in to text file from the table.echo "Enter User Name "read nameecho "Enter passwd "stty -echoread passstty echoecho "Enter Detp no"read dnosqlplus -S $name@oracle/$pass<

Ramakrishna.P

• Aug 30th, 2006

 

Hi all,

By using shell script,

#!user/bin/bash

sqlplus ' / as sysdba ' >>EOF

startup

shutdown immediate >>EOF

cmanne

 Profile Answers by cmanne 

• Mar 25th, 2007

 

Hi,
In oreder to connect to a database using a shell script it is always necessary to set the environment first and then connect to the database and execute whatever the statements u need to and come out of the script gracefully.

ex:
#!/bin/sh
export ORACLE_SID=$1
export ORACLE_HOME=more /etc/oratab|grep -v '#'|grep -i $1|cut -d":" -f2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export PATH=$ORACLE_HOME/bin:$HOME/bin:$PATH

sqlplus -s sys/<passwd> as sysdba <EOF
select name from v$database;
archive log list;
exit
EOF

The above script echoes the name of the database you are connected along with the archive log mode information.

jrgalaura

 Profile Answers by jrgalaura 

• Oct 27th, 2008

 

To connect to sybase, write this in the command line:

isql -Sservername -Uusername -Ppassword
1>use database
2>go

when you're done, just type quit.

Although i don't recommend using the -P option as other people might see your password.

Vamshidhar

 Profile Answers by Vamshidhar 

• Jan 14th, 2009

 

IF the Database is DB2 then the script is :

db2 "connect to $dbname user $userid using $password"

Anubhaw.Agrawal

 Profile Answers by Anubhaw.Agrawal 

• Apr 22nd, 2010

 

$ORACLE_HOME/bin/sqlplus username/password@remote_db