Sybase

supported

Notes

General:

DB engine as service

y

own authentication

y

Trusted authentication

n

Connection:

OLE DB

n

not supported by MapForce

ODBC

y

ODBC connection-string issues

Select Method=Cursor

must be applied

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

sub select support

y

JOIN support

y

MF: upper function

UPPER()

SQL-Execution:

exec. multiple-stat. in one

y

command separator

none

special error handling

n

retrieve parameter types

special issues when using ?

y

only ASCII-127 characters are allowed in string constants when using ODBC

Transactions:

Flat transactions supported

y

Start flat-transaction via execution of SQL-command

not supported by MAPFORCE

Nested transactions supported

n

Sybase does not produce an error, continues if no nested transactions exist

set transaction isolation

y

MF: begin transaction

API-call

MF: commit transaction

API-call

MF: rollback transaction

API-call

MF: set save point

SAVE TRANSACTION

MF: rollback to save point

ROLLBACK

MF used init. Statements

none