Limitations

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 IBM's DB2 LUW 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 LUW Command Reference for other limitations.