Database Administrator Guide > Database Administrator Guide > Loading and Unloading Databases > Unload Data into a CSV File (X100 Tables Only)
Was this helpful?
Unload Data into a CSV File (X100 Tables Only)
The INSERT INTO EXTERNAL CSV statement writes an X100 table to a local file system. The result is either a single CSV file or a collection of CSV files, depending on whether the query is run in parallel. For more information on this statement, see the SQL Reference Guide. For example:
Export data in the supplier table to a file named supplier.csv and insert the text NULL for null values:
INSERT INTO EXTERNAL CSV 'tmp/supplier.csv' SELECT * FROM supplier WITH NULL_MARKER='NULL'
Last modified date: 01/30/2023