# 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