Hi, You can use sqlcli for this task. It is available at: ftp://ftp.sap.com/pub/maxdb/tmp/maxdb-sqlcli-linux-i386-7_5_1_0a.tgz
Use sqlcli -d <dbname> -u <user>,<password> -i <batchfile> To separate the sql commands within the batchfile use the following format: Select 'homer' from dual // Select 'bart' from dual // ... You can also modify the separator via a command line option (see sqlcli -h). Regards, Marco ----------------- Marco Paskamp SAP Labs, Berlin -----Original Message----- From: Matthias G�rtner [mailto:[EMAIL PROTECTED] Sent: Montag, 24. Mai 2004 18:27 To: [EMAIL PROTECTED] Subject: Loading large SQL scripts w/o SQL Studio: how? Dear list, we have large SQL batch files which we cannot load via SQL Studio (tunneled connection only, takes ages). We would like to transfer the data to the server (no GUI there, Linux), then use dbmcli or similar to load the SQL. Basically we would like to simulate Oracle's "sqlplus @mybigbatch.sql". I'm sure the answer to this is trivial, but I don't see it. Any pointer appreciated. Thank you, Matthias -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
