Adelia Studio was tested with the most widely-used mobile DBMS versions during the development process.
The following mobile DBMS products are supported:
- DB2 Everyplace 8.2
- SQL Server CE 2.0
- Oracle lite 10g
In general, any restrictions relating to the use of PC databases also apply to equivalent mobile DBMS solutions, with mobile versions being subject to some additional restrictions:
- It is generally not possible to open multiple simultaneous connections to the same database, whether they are on the same or different logical servers, and in the same process or different processes.
- Exception: DB2 Everyplace supports simultaneous connections, but only within the same process (for Adelia, for example, on different logical servers).
- By extension (except in the special case of DB2 Everyplace) no record locking concept is used. Therefore, the *LOCKED keyword always returns *FALSE.
- With DB2 Everyplace, support for the IMAGE type is restricted to images smaller than 32 kilobytes.
- Currently, no database management system is supplied with Adelia Studio for mobile databases.
- SQL scalar functions are not fully supported.