Allows you to execute SQL commands and run command files against databases running on Windows Mobile.
dbrunsql [ options ] [ SQL-script-file | SQL-command ]
Option | Description |
---|---|
-c "keyword=value; ..." | Specifies connection parameters. See Connection parameters. |
-d | Writes data exported from result sets to the output file. If you do not specify -d, then all dbrunsql output is written to the output file. |
-e [ c | p | s ] |
Controls the behavior when an error is encountered while executing statements. By default, dbrunsql prompts the user when an error occurs.
|
-f [ f | a ] |
Specifies the data format dbrunsql uses to export result sets. You can specify one of the following values:
|
-g [ + | - ] | Prevents the GUI from appearing. By default, the dbrunsql GUI appears. |
-o filename | Writes output messages to the named file. |
-q |
Suppresses output messages. This is useful only if you start Interactive SQL with a command or command file. Specifying this option does not suppress error messages, but it does suppress the following:
|
-qc | Closes the dbrunsql window once the command or script file has been executed. |
-s number | Specifies the maximum number of bytes fetched per column when you are exporting result sets using the FIXED format. The default value is 255. |
-v | Includes all lines of each SQL statement in the dbrunsql output. Otherwise, when you execute a script file, the number of the line that is currently being executed appears. |
The dbrunsql utility allows you to execute SQL commands or run command files against a database. The SQL Anywhere Script Execution utility (dbrunsql) is only supported on Windows Mobile.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |