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

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.

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