IBM DB2
Requirements
IBM DB2 support relies on the IBM DB2 .NET provider, shipped with the latest ClientAccess version, also available through the DB2 personal edition installation, or through the IBM website for DB2 licensees. To be able to create a model from an existing DB2 schema, you have to have access to a DB2 instance, version v7.x. IBM DB2 on AS\400 / iSeries isn't supported.
Supported features
| Feature | Supported |
|---|---|
| Minimal database version | DB2 v7.x |
| Database types | All built-in types |
| User defined types | No |
| Foreign key constraints | Yes |
| Primary key constraints | Yes |
| Unique constraints | Yes |
| Check constraints | No |
| Default values | Yes |
| Unique indexes | No |
| Tables | Yes |
| Views | Yes |
| Stored Procedures | Yes |
| Table Valued Functions | No |
| (System versioned) Temporal tables | Yes, both Business Time and System Time oriented temporal tables. |
| Synonyms | NO |
| Cascade delete rules | No |
| Cascade update rules | No |
| Identity fields | Yes |
| System sequences | Yes |
| Schema based sequences | Yes |
| Multiple catalogs per project | No |
| Multiple schemas per catalog | Yes |
| Linked servers | No |
Type mappings
Below you'll find the two type mapping tables used by the IBM DB2 driver of LLBLGen Pro. One is used for Database First development, the other is used for Model First development. In case of Model First development, you can add your own type shortcuts to define a different target database type, in case the default mappings aren't what you need in a particular case.
Global model-first type overruling
For Model first, there are often multiple database types defined per .NET Type and a given filter. To prefer one over the other on a global level, please look at the following settings in the Relational model data element construction section of the Project Settings:
- Prefer natural character types
- Prefer decimal over currency types
- Prefer variable length types
Database first type mappings
You can control the .NET type during reverse engineering in database first development by defining Type Conversions in the Project Settings, which are based on Type Converters.
| Database type | .NET Type |
|---|---|
| BigInt | System.Int64 |
| Binary Large Object | System.Byte[] |
| Blob | System.Byte[] |
| Char For Bit Data | System.Byte[] |
| Char Large Object | System.String |
| Char Varying For BitData | System.Byte[] |
| Char Varying | System.String |
| Character For Bit Data | System.Byte[] |
| Character Large Object | System.String |
| Character Varying For BitData | System.Byte[] |
| Character Varying | System.String |
| Character | System.String |
| Char | System.String |
| Clob | System.String |
| Date | System.DateTime |
| DbClob | System.String |
| Decimal | System.Decimal |
| Dec | System.Decimal |
| Double Precision | System.Double |
| Double-Byte Char Large Object | System.String |
| Double-Byte Character Large Object | System.String |
| Double | System.Double |
| Float | System.Double |
| Graphic Varying | System.String |
| Graphic | System.String |
| Integer | System.Int32 |
| Int | System.Int32 |
| Long Graphic Varying | System.String |
| Long VarChar For BitData | System.Byte[] |
| Long VarChar | System.String |
| Long VarGraphic | System.String |
| Numeric | System.Decimal |
| Num | System.Decimal |
| Real | System.Single |
| SmallInt | System.Int16 |
| TimeStamp | System.DateTime |
| Time | System.TimeSpan |
| VarChar For BitData | System.Byte[] |
| VarChar | System.String |
| VarGraphic | System.String |
| Xml | System.String |
Model first type mappings
If specified, the filter is combined with the .NET type to determine the database type. The elements length, precision and scale
are the max. length, precision and scale of an entity field with the particular .NET Type. For instance a field with type System.String, max. length set to 50, will with all defaults enabled, a database type of NVarChar(50).
If a controlling setting is specified, that setting has to be set to the specified value (in the Relational model data element construction section of the Project Settings) to make the designer select that database type.
| .NET Type | Filter | Database type | Controlling setting and value |
|---|---|---|---|
| System.Byte[] | 0 < length < 32672 | VarCharForBitData(length) | |
| System.Byte[] | length==0 or length >= 32672 | Blob | |
| System.DateTime | Date | ||
| System.Decimal | Decimal(precision, scale) | Prefer decimal over currency types set to true | |
| System.Double | Float | ||
| System.Int16 | SmallInt | ||
| System.Int32 | Int | ||
| System.Int64 | BigInt | ||
| System.Single | Real | ||
| System.String | 0 < length < 254 | Char(length) | Prefer variable length types set to false |
| System.String | 0 < length < 254 | VarChar(length) | Prefer variable length types set to true |
| System.String | 255 < length < 32672 | VarChar(length) | |
| System.String | length==0 or length >= 32672 | Clob | |
| System.TimeSpan | Time |
Supported target frameworks
The following target frameworks are supported with IBM DB2:
- LLBLGen Pro Runtime Framework
- Entity Framework v1-v6
- NHibernate