Effective in version 6.3, you can copy specific column values to a CSV file. To copy column values, you use the LOG modifier at the end of the UPDATE and PURGE TABLE commands.
UPDATE
You can copy specific column values to a CSV file. The column values that you can copy are for the rows that you want to put on legal hold with the UPDATE command.
Use the following syntax:
UPDATE <table-name> FROM FILE 'update-file-path' [LOG {col1,… colN} INTO ‘CSV_file_path’;
PURGE TABLE
You can copy specific column values to a CSV file. The column values that you can copy are for the rows that you want to physically delete with the PURGE TABLE command.
Use the following syntax:
PURGE TABLE <table-name> [LOG { col1,… colN} INTO ‘CSV_file_path’;