Online Documentation for SQL Query for DB2
Exporting the result dataset (e.g. when it is necessary to move the result of a query execution to a data medium) is implemented in SQL Query for DB2 as the following facilities:
- exporting the dataset to a file of one of the supported formats (MS Excel, MS Access, RTF, HTML, PDF, TXT, CSV, etc.) can be performed with Data Export for DB2 used (if the latter is installed on your system): use the Export Data toolbar button to start the export utility and follow the steps of the wizard to complete the exporting process;
- copying the dataset to Windows clipboard (e.g. when you need to paste it afterwards to a third-party editor): use the Export Data to Clipboard toolbar button for this purpose.
Note: To perform export to a *.accdb file Microsoft Access Database Engine 2010 Redistributable is required.