dbisqlc utility (deprecated)

dbisqlc [ options ] [ dbisqlc-statement | dbisql-script-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 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
-x	Scans statements but does not execute them. This is useful for checking long script files for syntax errors.

The dbisqlc utility allows you to type SQL statements or run SQL script files.

If dbisqlc-statement is specified, dbisqlc executes the statement. You can also specify a script file name. If no dbisqlc-statement or dbisql-script-file argument is specified, dbisqlc enters interactive mode, where you can type a statement into a command window.

The dbisqlc utility is available on Microsoft Windows, Mac OS X, and Unix.

Run the following command to run the script file mycom.sql against the current default server, using the user ID DBA and the password sql. If there is an error in the script file, the process shuts down.

dbisqlc -c "UID=DBA;PWD=sql" mycom.sql

Run the following command to add a user to the current default database:

dbisqlc -c "UID=DBA;PWD=sql" CREATE USER joe IDENTIFIED BY passwd

dbisqlc utility (deprecated)

Note

Syntax

Remarks

See also

Example