Allows you to execute SQL commands and run command files against databases running on Windows CE.
dbrunsql [ options ] [ SQL-script-file | SQL-command ]
| Option | Description |
|---|---|
| -c "keyword=value; ..." | Specify connection parameters. See Connection parameters. |
| -d | When this option is specified, only data exported from result sets is written to the output file. If you do not specify -d, then all dbrunsql output is written to the output file. |
| -e [ c | p | s ] |
This option controls what happens if an error is encountered while executing statements. By default, dbrunsql prompts the user when an error occurs.
|
| -f [ f | a ] |
Use this option to specify the data format dbrunsql uses to export result sets. You can specify one of the following values:
|
| -g [ + | - ] | By default, the dbrunsql GUI appears. Specify -g- if you do not want the GUI to appear. |
| -o filename | Write output messages to the named file. |
| -q |
Do not display 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 | Specify this option if you want the dbrunsql window to close once the command or script file has been executed. |
| -s number | When you are exporting result sets using the FIXED format, you can specify the maximum number of bytes fetched per column. The default value is 255. |
| -v | When you specify the -v option, all lines of each SQL statement appear 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 CE.