IBM Db2 - Export query result action ​

The export function runs a SQL query and exports its result set as a CSV file. The system uploads the CSV file to a local directory, or to cloud storage, such as an S3 bucket.

If using a local directory to upload the CSV file, the system processes and stores the query results locally, and the data never leaves your secure network.

Input ​

SQL

Required field

Provide the SQL query to select data for export.
Wrap datapills in single quote characters, '.

Column delimiter

Required field

Choose a delimiter character. Commonly, CSV files typically use comma.

Upload URL

Required field

Export the CSV file to this URL. Generate this url using On-prem files, or Amazon S3.

Output ​

Number of rows exported

The number of rows exported to the CSV file.

Column names

Column headers in the exported CSV file.