Laurent Vaills wrote:
You can use the -i option of dbmcli.
I use it like this :
dbmcli -n <host> -d <dbname> -u user,passwd -uSQL user,passwd -i
test.sql
or repmcli -n <host> -d <dbname> -u user,passwd -b test.sql
This is easier, as the sql_execute prefix is not needed ;-)
Your SQL statements in test.sql have to begin with sql_execute
Laurent
On Mon, 2003-01-06 at 14:14, Danny Tramnitzke wrote:
So there is no according option with dbmcli?
Where can I type 'xsql -h' ? It's no option of dbmcli ...
Danny
Hello Danny,
you can use xsql from the command line.
You can use it to get the commands from STDIN 'xsql < sql-file'
For more explanations about xsql use the -h option.
Regards,
Burkhard
-----Original Message-----
From: Danny Tramnitzke [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: execute sql-file on sapdb 7.4
Hi all
How can I execute a sql-file with several statements from linux command
line?
So I have access to the database with dbmcli but then I want to make a
number of sql-statements without type them in again and again.
Danny
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
