Overview

The command line interface:

  • Enables you to have a script file containing a list of queries separated by semicolons.

  • Returns a warning for SQL commands that return result sets, such as SELECT and LIST PERMISSIONS.

  • Runs multiple update queries in a single execution.

  • Optionally displays the current executing query.

The following table lists command line interface arguments:

Note: The command line arguments are case-sensitive. For example,

  • Lowercase p is password.

    Uppercase P is port.

  • Lowercase h is host.

    Uppercase H is help.

Argument

Description

-d <DATABASE> or --database <DATABASE>

The database name where <DATABASE> is the resource name in the configuration file.

-H or --help

(Optional field)

Shows a list of QDC command line interface arguments.

-host <HOSTNAME> or --hostname <HOSTNAME>

Host or server name

-i or --ignore

(Optional field)

If specified and errors are detected, the error message is displayed and the program continues to execute.

-p <PASSWORD> or --password <PASSWORD>

The password associated with the specified username.

-P <PORT> or --port <PORT>

The port number of the host name where <PORT> is replaced with the port number.

-s <FILE> or --script <FILE>

The script file attribute where <FILE> is the path to the script file.

Errors are reported in the error summary file, which is the script file title with an .err extension (<FILE>.err).

For example, for the script file C:\test.sql, the error file is C:\test.sql.err.

-u <USER> or --username <USER>

The username where <USER> is replaced with your usercode.

-V or --verbose

(Optional field)

If specified, the results of each query are displayed in the terminal.

Prev  Up  Next
Command Line Interface  Home  Argument Examples