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

 IBM Microdrive and Compact Flash Memory support
 IBM Microdrive and Compact Flash Memory support
DB2 Everyplace SQL

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