Using DataDirect Bulk Load on DB2
- Last Updated: April 16, 2026
- 1 minute read
- ADO.NET
- Documentation
DataDirect Bulk Load offers a one-stop approach for all of your bulk load needs, with a simple, consistent way to do bulk load operations for all of the DataDirect Connect products that support this feature (see Using DataDirect Bulk Load for information on how to use bulk load). This section contains specific information for the DB2 data providers.
Requirements and Limitations
The DB2 data provider has no special requirements or limitations for bulk load operations.
Native to XML Schema Data Type Mappings
The following table shows how native DB2DbTypes are mapped to XML schema data types for the bulk load configuration file.
Mapping DB2DbType Enumerations to XML Schema Data Types
| DB2DbType Enumerations | XML Schema Data Types |
| BFile | Longvarbinary |
| Blob | Longvarbinary |
| Byte | Longvarbinary |
| Char | Char |
| Clob | Longvarchar |
| Date | DateTime |
| Double | Double_precision |
| Float | Single_precision |
| Int16 | Smallint |
| Int32 | Integer |
| Int64 | BigInt |
| Long | Longvarchar |
| LongRaw | Longvarbinary |
| NChar | Unicode_varchar |
| NClob | Unicode_Longvarchar |
| Number | Decimal |
| Nvarchar | Unicodevarchar |
| Raw | Varbinary |
| Refcursor | VarChar |
| RowId | Varchar |
| Sbyte | Tinyint |
| Timestamp | DateTime |
| Timestamplocal | DateTime |
| Timestampwithtz | Datetime_with_tz |
| Uint16 | Unsigned_smallint |
| Uint32 | Unsigned_integer |
| Uint64 | Unsigned_bigint |
| VarChar | VarChar |
| XmlType | Xml_text |