Script Execution utility (dbrunsql)

Allows you to execute SQL commands and run command files against databases running on Windows Mobile.

Syntax

dbrunsql [ options ] [ SQL-script-file | SQL-command ]

Option	Description
-c "keyword=value; ..."	Specify connection parameters. See Connection parameters.
-d	Write 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 ]	Control the behavior when an error is encountered while executing statements. By default, dbrunsql prompts the user when an error occurs. c Ignore the error and continue executing statements. p Prompt the user to see if the user wants to continue. s Stop executing statements.
-f [ f \| a ]	Specifies the data format dbrunsql uses to export result sets. You can specify one of the following values: a Use ASCII format when exporting data. f Use FIXED format when exporting data. This is the default format.
-g [ + \| - ]	Prevent the GUI from appearing. By default, the dbrunsql GUI appears.
-o filename	Writes output messages to the named file.
-q	Suppress 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: warnings and other non-fatal messages the printing of result sets
-qc	Close the dbrunsql window once the command or script file has been executed.
-s number	Specify the maximum number of bytes fetched per column when you are exporting result sets using the FIXED format. The default value is 255.
-v	Include 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.

Remarks

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.

Send feedback about this page via email or DocCommentXchange