IBM DB2

Important!

Starting with v5.10, IBM DB2 has been deprecated and won't receive any new features nor will it be kept up to date with IBM DB2 releases.

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