The following tables summarize some of the key similarities and differences between the ingest, import, and load utilities.
Table type | Ingest | Load | Import |
---|---|---|---|
Detached table | not supported | not supported | not supported |
Global temporary table | not supported | not supported | not supported |
Multidimensional clustering (MDC) or insert time clustering (ITC) table | supported | supported | supported |
Materialized query table (MQT) that is maintained by user | supported | supported | supported |
Nickname | supported | not supported | supported |
Range-clustered table (RCT) | supported | not supported | supported |
Range-partitioned table | supported | supported | supported |
Summary table | supported | supported | supported |
Temporal table | supported | supported | supported |
Typed table | not supported | not supported | supported |
Untyped (regular) table | supported | supported | supported |
Updatable view (except typed view) | supported | not supported | supported |
Table type | Ingest | Load | Import |
---|---|---|---|
Numeric: SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, DECFLOAT | supported | supported | supported |
Character: CHAR, VARCHAR, NCHAR, NVARCHAR, plus corresponding FOR BIT DATA types | supported | supported | supported |
Graphic: GRAPHIC, VARGRAPHIC | supported | supported | supported |
Long types: LONG VARCHAR, LONG VARGRAPHIC | supported | supported | supported |
Date/time: DATE, TIME, TIMESTAMP, including TIMESTAMP(p) | supported | supported | supported |
DB2SECURITYLABEL | supported | supported | supported |
LOBs from files: BLOB, CLOB, DBCLOB, NCLOB | not supported | supported | supported |
Inline LOBs | not supported | supported | supported |
XML from files | not supported | supported | supported |
Inline XML | not supported | supported | supported |
Distinct type | supported (if based on a supported built-in data type) | supported | supported |
Structured type | not supported | not supported | supported |
Reference type | supported | supported | supported |
Input type | Ingest Restartable? |
Load Restartable? |
Import Restartable? |
---|---|---|---|
Cursor | not supported n/a |
supported yes |
not supported n/a |
Device | not supported n/a |
supported yes |
not supported n/a |
File | supported yes |
supported yes |
supported yes |
Pipe | supported yes |
supported yes |
not supported n/a |
Table type | Ingest | Load | Import |
---|---|---|---|
ASC (including binary) | supported | supported | supported |
DB2® z/OS® UNLOAD format | not supported | not supported | not supported |
DEL | supported | supported | supported |
IXF | not supported | supported | supported |