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" Copy

• 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" Copy

• Execute a file with SQL statements:

  • zowe db2 execute sql --file backup_sample_database.sql Copy