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