The Import Data tool has the following limitations:
- Data for all columns in a table must be in import file. There is no ability in this tool to limit the column data being inserted.
- Import formats WSF (Lotus worksheet) and IXF (mainframe) are not supported.
- IXF and DEL files are imported using IBM's IMPORT application programming interface. Some options of the API are not supported. See IBMDB2 Command Reference for list of all available options.
- DSNTIAUL files are converted to ANSI delimited format and then use the DEL IMPORT API.
- LOB data types are not supported in DSNTIAUL format.
- LOB data types generated as part of file in IXF and DEL formats. See IBM's DB2 Command Reference for other limitations.