IBM DB2

supported

Notes

General:

DB engine as service

y

own authentication

y

uses local windows user-accounts

Trusted authentication

y

see 'own authentication'

Connection:

OLE DB

n

not supported by MapForce

ODBC

y

JDBC

y

via ODBC

MF used init. Statements

none

MF used final. Statements

none

SQL:

DB-object-name qualification

""

support for DB-schemas

y

identity support

y

MF: read back identity value

identity_val_local()

sub select support

y

JOIN support

y

MF: upper function

UPPER()

SQL-Execution:

exec. multiple-stat. in one

n

command separator

--

special error handling

y

retrieve parameter types

n

special issues when using ?

n

Transactions:

Flat transactions supported

y

Start flat-transaction via execution of SQL-command

n

Nested transactions supported

n

not supported by DB2

set transaction isolation

y

MF: begin transaction

API-call

MF: commit transaction

API-call

MF: rollback transaction

API-call

MF: set save point

--

not supported by DB2

MF: rollback to save point

--

not supported by DB2

MF used init. Statements

none