[MonetDB-users] Executing a SQL file from the MAPI command line
Is there a way I can execute a set of SQL commands which are stored in a file using MAPI client? I understand that I can execute a single statement using "-s" option. This allows me to execute only one single statement. I would like to execute more than one statement that are stored in a file from the command line.
Thanks,
-Venks
Venks wrote:
Is there a way I can execute a set of SQL commands which are stored in a file using MAPI client? I understand that I can execute a single statement using "-s" option. This allows me to execute only one single statement. I would like to execute more than one statement that are stored in a file from the command line.
MapiClient -lsql < your_file.sql
Regards, Romulo
Thanks,
-Venks
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Romulo Goncalves wrote:
Venks wrote:
Is there a way I can execute a set of SQL commands which are stored in a file using MAPI client? I understand that I can execute a single statement using "-s" option. This allows me to execute only one single statement. I would like to execute more than one statement that are stored in a file from the command line.
MapiClient -lsql < your_file.sql
Or just MapiClient -lsql your_file.sql This is probably slightly more efficient.
participants (3)
-
Romulo Goncalves -
Sjoerd Mullender -
Venks