IBM DB2 Everyplace 7.2.1 - Manual (Page 12)

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 23-24