## 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`