## zowe › db2 › execute › sql

Execute one or multiple SQL statements separated by a semicolon from a command line or from a file.

#### Usage

zowe db2 execute sql [options]

#### Options

- `--query` | `-q` (string)

  - The SQL statement verbatim to execute

- `--file` | `-f` (string)

  - A local file containing the SQL statements to execute

#### DB2 Connection Options

- `--host` | `-H` (string)

  - The Db2 server host name

- `--port` | `-P` (number)

  - The Db2 server port number

- `--user` | `-u` (string)

  - The Db2 user ID (may be the same as the TSO login)

- `--password` | `--pass` | `--pw` (string)

  - The Db2 password (may be the same as the TSO password)

- `--database` | `--db` (string)

  - The name of the database

- `--sslFile` | `--ssl` (string)

  - Path to an SSL Certificate file

#### Profile Options

- `--db2-profile` | `--db2-p` (string)

  - The name of a (db2) profile to load for this command execution.

- `--base-profile` | `--base-p` (string)

  - The name of a (base) profile to load for this command execution.

#### Base Connection Options

- `--reject-unauthorized` | `--ru` (boolean)

  - Reject self-signed certificates.

    Default value: true

- `--token-type` | `--tt` (string)

  - The type of token to get and use for the API. Omit this option to use the default token type, which is provided by 'zowe auth login'.

- `--token-value` | `--tv` (string)

  - The value of the token to pass to the API.

- `--cert-file` (local file path)

  - The file path to a certificate file to use for authentication.

    Note: The CLI does not support certificate files that require a password. For more information, search Troubleshooting PEM Certificates in Zowe Docs.

- `--cert-key-file` (local file path)

  - The file path to a certificate key file to use for authentication

#### Examples

- Execute a dummy SQL query:

  - `zowe db2 execute sql --query "SELECT 'Hello World' FROM SYSIBM.SYSDUMMY1"`

- Retrieve the employees table and total number of rows:

  - `zowe db2 execute sql -q "SELECT * FROM SAMPLE.EMP; SELECT COUNT(*) AS TOTAL FROM SAMPLE.EMP"`

- Execute a file with SQL statements:

  - `zowe db2 execute sql --file backup_sample_database.sql`