Allows you to execute SQL statements and run script files against databases running on Windows Mobile.
Syntaxdbrunsql [ options ] [ SQL-script-file | SQL-statement ]| 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 statement or script file. Specifying this option does not suppress error messages, but it does suppress the following:
|
| -qc | Closes the dbrunsql window once the statement 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 run a script file, the number of the line that is currently being executed appears. |
PrivilegesNone.
RemarksThe dbrunsql utility allows you to execute SQL statements or run script files against a database. The SQL Anywhere Script Execution utility (dbrunsql) is only supported on Windows Mobile.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |