Micro Focus Studio Enterprise Edition for Windows > Programming > Data Access > Database Access > DB2 > Host Compatibility Option (HCO) > HCO Tools > Exporting Data > Limitations

Limitations

The Export Data tool has the following limitations:

All columns and rows in a table are exported. There is no ability in this tool to limit the data or rows exported.
Export formats WSF (Lotus worksheet) and IXF (mainframe) are not supported
IXF and DEL files are exported using IBM's EXPORT application programming interface. Some options of the API are not supported. See IBM's DB2 LUW Command Reference for list of all available options.
DSNTIAUL is exported using a SELECT statement, so large tables may take a while to process
LOB data types are not supported in DSNTIAUL format
LOB data types are generated as part of file in IXF and DEL formats. See IBM's DB2 LUW Command Reference for other limitations.

If you need to restrict rows and/or columns exported, you can use the IBM command line processor, DB2 or the IBM Control Center to export data. See IBM's DB2 LUW Command Reference for more details on how to use the IBM Control Center.