The dbisqlc utility executes SQL statements against a database. The utility is similar to the Interactive SQL utility (dbisql), except that it is not implemented in Java, which can be important if you are deploying it to a computer with limited resources.
dbisqlc is deprecated; however, there are currently no plans to remove it. It is provided for backwards compatibility for running SQL scripts and as a lightweight tool for deployment. dbisqlc does not support all the features that Interactive SQL supports and may not support all the features available in the current version of the database server. It is recommended that you use the Interactive SQL utility (accessed by using the dbisql command or by choosing Start » Programs » SQL Anywhere 11 » Interactive SQL). See Interactive SQL utility (dbisql).
dbisqlc [ options ] [ dbisqlc-command | command-file ]| Option | Description |
|---|---|
| -c "keyword=value; ..." |
Specifies connection parameters. If Interactive SQL cannot connect, you are presented with a window where you can enter the connection parameters. See Connection parameters. |
| -d delimiter |
Specifies a command delimiter. Quotation marks around the delimiter are optional, but are required when the command shell itself interprets the delimiter in some special way. The specified command delimiter is used for all connections in the current dbisqlc session. |
| -q |
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:
|
| -x |
Scans commands but does not execute them. This is useful for checking long command files for syntax errors. |
The dbisqlc utility allows you to type SQL commands or run command files. For detailed descriptions of SQL statements and Interactive SQL commands, see SQL language elements.
If dbisqlc-command is specified, dbisqlc executes the command. You can also specify a command file name. If no dbisqlc-command or command-file argument is specified, dbisqlc enters interactive mode, where you can type a command into a command window.
The dbisqlc utility is supported on Microsoft Windows, Mac OS X, and Unix.
The following command runs the command file mycom.sql against the current default server, using the user ID DBA and the password sql. If there is an error in the command file, the process shuts down.
dbisqlc -c "UID=DBA;PWD=sql" mycom.sql |
The following command adds a user to the current default database:
dbisqlc -c "UID=DBA;PWD=sql" CREATE USER joe IDENTIFIED BY passwd |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |