
DB2 Everyplace Characteristics
RDBMS especially made for mobile devices and embedded systems ![]()
API's
DB2 Call Level Interface (CLI) / ODBC subset
A set of C/C++ function can be called in programs to access the database
JDBC and Java application support
DBCS (double byte character set) and NLV support ![]()
Encryption (communication)
![]()
IBM Microdrive and Compact Flash Memory support
DB2 Everyplace SQL

Supports a subset of SQL
CALL procedure
CREATE INDEX (asc/desc) bidirectional
CREATE TABLE
DROP TABLE/INDEX
EXPLAIN
INSERT with subselects and default values
DELETE
UPDATE (records)
SELECT (records) with
JOIN ( up to 8 tables)
GROUP BY
ORDER BY (asc/desc)
LIMIT (integer) for result set
IN predicate
scrollable cursors
Page