topic Re: how to connect to database in shell script in Operating System - HP-UX

how to connect to database in shell script

fjatu — Fri, 22 Mar 2002 07:44:36 GMT

Whether or not connect to database or excute sql statement in shell script?please give me some documents.thank you!

Re: how to connect to database in shell script

John Carr_2 — Fri, 22 Mar 2002 07:47:13 GMT

Hi

please would you could tell us what type of database and release.

cheers
John.

Re: how to connect to database in shell script

Tom Geudens — Fri, 22 Mar 2002 07:50:03 GMT

Hi,
If this is oracle we are talking this would be a way (there's several other ways) :

#!/bin/ksh
sql_logon=$1
sql_script=$2
$ORACLE_HOME/bin/sqlplus << !! 2>&1 >tgd008.log
$sql_logon
@$sql_script;
quit
!!

Hope this helps,
Tom Geudens

Re: how to connect to database in shell script

Deepak Extross — Fri, 22 Mar 2002 08:06:12 GMT

If you're talking informix,

#!/usr/bin/ksh
isql <

Re: how to connect to database in shell script

Printaporn_1 — Fri, 22 Mar 2002 08:30:17 GMT

Hi,

for oracle

sqlplus << EOF
select * from tab;
EOF

Re: how to connect to database in shell script

Magdi KAMAL — Wed, 27 Mar 2002 12:39:00 GMT

Hi Fiatu,

Here is what you need :

1. Remote database

#sqlplus userName/passWord@OracleInstance< /tmp/output.log 2>&1
select ....
insert ....
delete ....
update ....

EOD

The name "OracleInstance" is the name of the oracle instance defined in the file tnsnames.ora

2.Local database

#sqlplus userName/passWord< /tmp/output.log 2>&1
select ....
insert ....
delete ....
update ....

EOD

HTH

Magdi

Re: how to connect to database in shell script

harry d brown jr — Wed, 27 Mar 2002 13:02:07 GMT

It's PERL time:

use strict;
use DBI;

my $dbh = DBI->connect( 'dbi:Oracle:orcl',
'jeffrey',
'jeffspassword',
{
RaiseError => 1,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";

my $sql = qq{ CREATE TABLE employees ( id INTEGER NOT NULL,
name VARCHAR2(128),
title VARCHAR2(128),
phone CHAR(8)
) };
$dbh->do( $sql );

$dbh->disconnect();

http://www.saturn5.com/~jwb/dbi-examples.html

live free or die
harry