Allows you to execute SQL commands and run command files against databases running on Windows Mobile.
dbrunsql [ options ] [ SQL-script-file | SQL-command ]
|-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.|
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|