Script Execution utility (dbrunsql)

Allows you to execute SQL statements and run script files against databases running on Windows Mobile.

Syntax

dbrunsql [ 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. 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 [ + \| - ]	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: warnings and other non-fatal messages the printing of result sets
-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.

Remarks

Discuss this page in DocCommentXchange.