[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Re: how to run a SQL batch file with dbmcli
From:       Juergen Sauer <jojo () automatix ! de>
Date:       2002-09-21 21:26:02
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am Freitag, 20. September 2002 04:35 schrieb Harry Cai:
> Hello,

> How to run a SQL batch file with dbmcli?
Through repmancli:
Like this example:
- --------x--------------x----------------x----------------x--------------x----------
#!/bin/bash
# Set your own Parameter below:
# Your DB Access
DB=YOURDBINSTANCE
DBNODE=db.server.host.fqdn.com
DBUSER=dba,dba
# REPNODE=db.server.host.fqdn.com
# or localhost, if your host has got a SapDB installation, vserver running
REPNODE=localhost
REPMANCLI=/usr/sapdb/depend/bin/repmcli
# Error Level/Number tolerated
# Dont Stop at all set it to 0
# Stop at first Error set it to 1
ERRORCOUNT=1
###########################################################
 
if [ ! -x $REPMANCLI ] ;  then
    echo $REPMANCLI ist nicht ausführbar, Exit
    exit 1
fi

REPMANCLI="$REPMANCLI -d $DB -n $DBNODE -u $DBUSER -r $REPNODE -E $ERRORCOUNT"

while ( test -n "$1" )
do
  if [ -f "$1" ] ; then
      echo "Exec: $1"
      $REPMANCLI -b $1
  fi
  shift 1
done
- --------x--------------x----------------x----------------x--------------x----------

Hope this helps
	Jojo
- -- 
Jürgen Sauer - AutomatiX GmbH, +49-4209-4699, jojo@automatix.de **
** Das Linux Systemhaus - Service - Support - Server - Lösungen **
http://www.automatix.de to Mail me: remove: -not-for-spawm-     **
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj2M4+0ACgkQW7UKI9EqarEn+QCgwzOmQnV2ULhhLRZQM5eE3Ob7
w5QAn0TixPVUCAGZx6uxDXTXkEOWmK+1
=3ota
-----END PGP SIGNATURE-----

_______________________________________________
sapdb.general mailing list
sapdb.general@listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
[prev in list] [next in list] [prev in thread] [next in thread]