-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Am Montag 19 August 2002 15:33 schrieb [EMAIL PROTECTED]:
> Hi!
> I want to load a very big file that contains instructions SQL, like
> 'create table' and 'insert'.
> I tried use 'SQL Studio' but was very slow.
> I'd like to know what is the better way or the correct tools to do
> this.
I do such tasks like this Script sql-execute:
- ---- sql-execute ----x------x-------x-------x---
#!/bin/bash
REPMANCLI=/usr/sapdb/depend/bin/repmcli
if [ ! -x $REPMANCLI ] ; then
echo $REPMANCLI not executeable, Exit
exit 1
fi
DB=DBINSTANCE
DBNODE=pc1
DBUSER=dba,dba
REPNODE=pc1
REPMANCLI="$REPMANCLI -d $DB -n $DBNODE -u $DBUSER -r $REPNODE -E 0"
while ( test -n "$1" )
do
if [ -f "$1" ] ; then
echo "Exec: $1"
$REPMANCLI -b $1
fi
shift 1
done
-
-----------------------x---------------------x----------------------x---------------x--
Save it as "sql-execute", make your changes to DB, DBNODE, DBUSER, REPNODE
as your environement needs.
Run it like this:
./sql-execute file1.sql file2.sql file3.sql ...
Be happy.
you find more such stuf on http://sapdb.automatix.de
Good SQL-ing.
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
iEYEARECAAYFAj1hAZYACgkQW7UKI9EqarGk9QCgyaE1RkmLusbFzVL7ZNjmdmEW
v1sAn21/A+AowN8CI38P+XOSz9gWTLlP
=Qwz8
-----END PGP SIGNATURE-----
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
