# IBM Db2 - Export query result

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.

# Export query result

# Input fields

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 fields

Number of rows exported
The number of rows exported to the CSV file.
Column names
Column headers in the exported CSV file.


Last updated: 2/20/2024, 5:01:26 PM