-----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, [EMAIL PROTECTED] **
** 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
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
