zowe › db2 › export › table🖨️

Export a Db2 table to the stdout or a file.

Usage

zowe db2 export table <table> [options]

Positional Arguments

• table (string)

  • The name of the table to export

Options

• --outfile | -o (string)

  • The path to the output file

• --separator | --sep (string)

  • Specify whether to add a separator between statements when exporting a table

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

• Export employees data from the table SAMPLE.EMP and save it to the file 'employees.sql':

  • zowe db2 export table SAMPLE.EMP --outfile employees.sql Copy