Export data with the UNLOAD statement

The UNLOAD statement is similar to the OUTPUT statement in that they both export query results to a file. However, the UNLOAD statement exports data more efficiently in a text format. The UNLOAD statement exports with one row per line, with values separated by a comma delimiter.

Use the UNLOAD statement to unload data when you want to:

  • export query results if performance is an issue

  • store output in text format

  • embed an export statement in an application

  • export data to a file on a client computer

 Impact on the database
 Example
 See also